Dynamic Charts/Graphs

[Cranford803]

I recently created a dynamic chart using: peltiertech.com/Excel/Charts/DynamicLast12.html


Everything worked great, but I can't seem to get the labels to shift as well as the data. It stays at 1,2,3,4,5,6,7,8,9,10,11,12. When I write a formula to get the x axis to be dynamic as well, excel will not allow me to use a formula. Not much point in having a dynamic table if I have to go and adjust the X axis every time new data is entered.


How do i get the X axis to be dynamic? Thanks!!!

 

[Cranford803]

bump

 

[Steve=True]

If you are using Excel 2007 or greater do the following:

1) create a named range for the xaxis
2) select your chart and then choose Design Ribbon > Select Data
3) on the right of the dialog box select the Horizontal Catagory Axis Labels button
4) change the range to your named range in step 1 including the file name

Here is a visual step by step and video tutorial of what i mean:
http://www.exceldashboardtemplates.com/?p=688


Steve=True