Dynamic Charts with 2 categories

**marish86** · 05-23-2011, 12:10 PM

Hi,

I need to create a dynamic chart with two categories ..Year-Month (like in multi-level format). Anyone knows how to do this? If this is not possible, basically what I need is to change the data range of a chart one row down every month so a macro would be a lot help as well. Please see attachment for an example of how the data is displayed and how I need the Chart to look like. Thanks a lot for your help, I really appreciate it!!!

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

There are many examples on the forum.
Most use this reference, http://peltiertech.com/Excel/Charts/Dynamics.html

To have multi level categories you simple need to get the offset range to cover 2 columns rather than the usual 1.

**marish86** · 05-24-2011, 05:38 PM

Thank You!

Originally Posted by Andy Pope

There are many examples on the forum.
Most use this reference, http://peltiertech.com/Excel/Charts/Dynamics.html

To have multi level categories you simple need to get the offset range to cover 2 columns rather than the usual 1.