Excel Excel chart and Data Table

Jan 26, 2009
Reaction score
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.

Ironoverload (HH)


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question