Excel 2007 - Creating & editing charts and graphs

Excel 2007 - Creating & editing charts and graphs

Please note that I no longer own the domain ictteacher.com or maintain the website. I am no longer in teaching (thankfully!) but I can still be contacted if you have any questions. Just visit...

http://www.themightierpen.co.uk/ictteacher.shtml

...where you can drop me a line, as well as finding some of the old resources which used to be on the old site.

Category:

Education

Tags:

• Excel
• 2007
• creating
• editing
• charts
• graphs
• pie
• column
• bar
• wizard
• tutorial
• ictteacher

[ictteachercom]

@HagerTX - Try right clicking on a blank area of the graph and clicking 'Select Data'. A panel will pop up and you'll also be taken to the sheet where the data is stored.

You can click the little button to the right of the label which says 'Chart data range' (at the top of the pop up panel) and then select an area which includes an additional row or column.

Simply add your new data into this row or column and the graph will update automatically.

I hope this helps!

[ictteachercom]

No, I'm English (as I'm sure you can tell from my accent) and so I spell it the correct way. ;-)

[kataria88]

thanks heaps for such a great video. this is a great help for everyone out their trying to learn excel and its functions. people like you are real asset for our society and this guy is getting fussed about spellings......!!!!!!! jeeeeesss....anyway color is wrong the correct spelling is colour.....

[sammyjny]

really long tutorial for one simple charting exercise. If you are going to make such a long video, its nice to cover more charting such as line, bar, scatterplot, x-y vs 2-series, etc.

[Jasmine1973able]

Thank you so much , I didnt know how to move chat to anouther sheet!!

[TehMegaNoobZor]

Thanks!

[Jistga]

@kataria88 not in America

[irishbabekat]

How does one fix a chart and table that shrank accidently. Also how to fix all info on one sheet to print on same page. Print preview only show the chart and not other graphics. need for school project Help!

[HagerTX]

I have a 2007 Excel spreadsheet that someone else made, but I'm trying to make mods to it. One of the sheets/tabs is a graph (it plots historical stock data). I need to plot a new line on this existing chart....and I can't figure out how....If it's not too much trouble, if you could reply to this or send me a private message.

[kataria88]

thanks heaps for such a great video. this is a great help for everyone out their trying to learn excel and its functions. people like you are real asset for our society and this guy is getting fussed about spellings......!!!!!!! jeeeeesss....anyway color is wrong the correct spelling is colour.....