Chart Data References

[Gwill1983]

Hi all,

I have multiple charts set up in my spreadsheet showing revenue against email numbers. In all of the charts the horizontal axis is only showing the week number (which is what I want) except for the last chart which is showing three lots of numbers along the horizontal access. One of these is the week number, but it is showing 2 more numbers from the data within the chart.

Can anybody help me to understand how to make this show only the week number??

Thanks

Chris

 

[Dave Paradi]

It may be because Excel is incorrectly interpreting which cells make up the horizontal axis. Often Excel will make this mistake if the first data series does not include a value for the first category (or in your case the first two categories). In the Select Data dialog box for the last chart, check to see if the category axis labels are properly defined as just the cells that contain the week numbers. If needed, adjust the cell range. If you need to adjust the cell range, it may be necessary to also adjust the cell range for the data series as well since Excel likely misinterpreted those as well.

Hope that helps.

Dave