View Full Version : Excel Chart

Ron Bakker
20-07-2003, 12:23 PM
I'm Trying to make a chart for a five worksheet spreadsheet that I have made.
the spread sheet itself has worked out quite well but I am having trouble with the chart.
What I have is the results of each financial year at the bottom of each work sheet. So If I were to list them here it would go somthing like this.
'2001'!e15 '2002'!e15 '2003'!e15 '2004'!e15 '2005'!e15. So as one could see I need the results from these five years or worksheets.
& they would have results like $81,000 $83,000 $85,000 $87,000 $90,000
My y axis looks good with 0-$100,000 but my x just has 1 & I need the five years as listed.
So I guess I have two problems 1 I don't know how to format the x axis to show the five years. 2 I don't know how to get the results from each year onto the Graph.

20-07-2003, 12:37 PM
Make a summary page where you accumulate the figures for each year (can be on the same page as the chart). On the 'series' tab of the source daya page there is a source for the category x labels. Hightlight the cells with the years for this field.

Ron Bakker
20-07-2003, 08:08 PM
Sounds like an Idea worth trying.

21-07-2003, 12:01 AM
right click on the chart and select input data (if I remember correctly). you can then go and add or edit the data that is used in the chart. to add, select add and click in the source box. You can then click outside on the required spreadsheet and click on the cell(s) the you want. (hope this helps. Its been a while since I have played with excel charts.


Ron Bakker
21-07-2003, 07:57 AM
Cool I'll tr that too.