- Joined
- Jan 26, 2009
- Messages
- 1
- Reaction score
- 0
Hi there
I have a problem with a chart that I am working on in Excel 2003.
I have 7 data series 4 as bar charts 2 as line charts and a prediction line.
The 4 Bar chart series are on the Primary X axis and the 2 line chart elements are on the Secondary X axis.
My problem is that in the Data Table at the bottom of the chart, in the row above the rows with the legend it shows 1,2,3,4,5,6..............and so on, but It should read 03 Jan, 10 Jan, 17 Jan, 24 Jan..............................
The scales on the Y read 0-19,000 on the left and 0-100% on the right
I saw an article by John Peltier on this forum but I just couldn't apply it to this chart of mine can anyone please tell me where I'm going wrong here? I could mail my chart if needed.
Regards
Ironoverload (HH)
I have a problem with a chart that I am working on in Excel 2003.
I have 7 data series 4 as bar charts 2 as line charts and a prediction line.
The 4 Bar chart series are on the Primary X axis and the 2 line chart elements are on the Secondary X axis.
My problem is that in the Data Table at the bottom of the chart, in the row above the rows with the legend it shows 1,2,3,4,5,6..............and so on, but It should read 03 Jan, 10 Jan, 17 Jan, 24 Jan..............................
The scales on the Y read 0-19,000 on the left and 0-100% on the right
I saw an article by John Peltier on this forum but I just couldn't apply it to this chart of mine can anyone please tell me where I'm going wrong here? I could mail my chart if needed.
Regards
Ironoverload (HH)