Shift Graphs

**cpass** · 04-04-2011, 09:44 AM

Hi all,

You guys helped me a ton with my last post so I thought I would try again.

I was able to make the shifting graphs as I call them. My issue is that the graphs show the data wrong. They are two months behind. For example the Label of March is right but it shoudl January's data.

I have attached the xls so hopefully someone can shed some light.Call Stats 2011.xls

**Andy Pope** · 04-04-2011, 10:47 AM

Your series are only reference the data category labels via named ranges.
The data values are explict range references.

You need to add named ranges for the data you are trying to plot.

**cpass** · 04-04-2011, 11:44 AM

Hi Andy,

Thanks for the response. Would you be able to show me an example of what you are talking about? I am still fairly new to this.

Thanks,
Chris

**Andy Pope** · 04-05-2011, 04:20 AM

Have a read of this,
http://peltiertech.com/Excel/Charts/Dynamics.html

It will help explain how named ranges can be used. You already have a set of named ranges defined in the workbook. Not sure they are pointing to the correct cells for your charts though. Once you have corrected the named ranges you then need to update the charts, via the select data dialog, to use those named ranges.