Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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" wrote in message ... 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. |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
thanks
"Kelly O'Day" wrote: 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" wrote in message ... 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. |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
In article , mccall213
@discussions.microsoft.com says... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |