Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
mccall213
 
Posts: n/a
Default Last 12 months chart

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   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default Last 12 months chart

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   Report Post  
Posted to microsoft.public.excel.charting
mccall213
 
Posts: n/a
Default Last 12 months chart

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   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default Last 12 months chart

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Missing lines in chart w/x-axis with months 1-24... DendWrite Charts and Charting in Excel 2 May 10th 05 09:04 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 06:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"