Last 12 months chart

[mccall213]

I have a whole lot of charts that feed off of data that is broken down into
regions in the rows and months going across the top of columns. every thing
i found so far on dynamic charts works with date ranges going down a column,
not across. How do i get it to work the way my data is set up.

 

[Kelly O'Day]

Mccal213:

Have you considered transposing your source data? Dates in rows is the
convention because you have thousands of possible rows and only 256 columns.

You can select your data, copy and transpose with paste special. try it on a
copy sheet to see if you can live with the more standard approach.

If not, then you will need to adjust the offset formulas that are used in
dynamic chart range names.

...Kelly

 

[mccall213]

thanks

Mccal213:

Have you considered transposing your source data? Dates in rows is the
convention because you have thousands of possible rows and only 256 columns.

You can select your data, copy and transpose with paste special. try it on a
copy sheet to see if you can live with the more standard approach.

If not, then you will need to adjust the offset formulas that are used in
dynamic chart range names.

...Kelly

 

[Tushar Mehta]

I have a whole lot of charts that feed off of data that is broken down into
regions in the rows and months going across the top of columns. every thing
i found so far on dynamic charts works with date ranges going down a column,
not across. How do i get it to work the way my data is set up.

Kelly's suggestion is on the mark. But, if you must keep columns, just
adjust the OFFSET formula (assuming that's what you are using) to refer to
starting column and number of columns rather than starting row and number of
rows. For how, check XL help for the OFFSET function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions