| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 35718 | 2003-07-20 00:23:00 | Excel Chart | Ron Bakker (356) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 161342 | 2003-07-20 00:23:00 | 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. |
Ron Bakker (356) | ||
| 161343 | 2003-07-20 00:37:00 | 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. | wotz (335) | ||
| 161344 | 2003-07-20 08:08:00 | Sounds like an Idea worth trying. Cheers |
Ron Bakker (356) | ||
| 161345 | 2003-07-20 12:01:00 | Alternatively 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. Cheers Craigb |
Craigb (688) | ||
| 161346 | 2003-07-20 19:57:00 | Cool I'll tr that too. Thanks |
Ron Bakker (356) | ||
| 1 | |||||