Problem in Stock chart.
I am new in making charts. My problem is that in sheet4 the chart does not show the real stock numbers. I followed the 12 month rolling data chart example by Jon. But i can not figure out why it does not follow the stock number desinated to it.. Hlep is very much appreciated. Thank you in advance. Please see attach.
tink_
Hi
You chart appears to be 'the wrong way around' the numbers in the day column are the ones plotted while you actual stock numbers appear overhaead like a title. This can be easily corrected when building the chart using the wizard when you get to the bit where you select your range theres an option to choose the series (rows/column) just switch them around. Or go into the series tab and muanually set it up.
Also thats a hell of a lot of data for one chart its going to get very cramped you might want to look up scrolling charts or consider more than one chart.
Hope it helps
JR
Versions
Mac OS X 'Leopard'
Mac MS Office Excel 2004
Windows XP
MS Excel 2002
MS Excel 2003
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks