Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 28th 09, 02:03 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 23
Default Charts - Setting Data Area as a Variable

I have a set of monthly financial reports and associated charts.
I need all the charts to show data just up to the current month.
Up to now I have had to manually adjust the data area chart by chart at the
end of each month as I move the model from one month to the next.
What I need is to simply adjust one cell to state the new month number and
this will adjust the data areas for all the charts.
I have been experimenting with the OFFSET function plugged into the chart
data range but it seems that this is not allowed.
Can someone suggest an 'easy' way around this problem
--
JohnG

  #2   Report Post  
Old April 28th 09, 09:58 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Charts - Setting Data Area as a Variable

Hi,

You can not use the OFFSET function within the chart source dialog.
Rather you need to create a named range which uses the offset function.

More information can be found here,
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JohnG" wrote in message
...
I have a set of monthly financial reports and associated charts.
I need all the charts to show data just up to the current month.
Up to now I have had to manually adjust the data area chart by chart at
the
end of each month as I move the model from one month to the next.
What I need is to simply adjust one cell to state the new month number and
this will adjust the data areas for all the charts.
I have been experimenting with the OFFSET function plugged into the chart
data range but it seems that this is not allowed.
Can someone suggest an 'easy' way around this problem
--
JohnG




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
How can I create multiple charts using variable data? Ian Murphy Charts and Charting in Excel 1 January 26th 07 01:25 PM
Variable Names in Source Data References in Charts Teflon TA Charts and Charting in Excel 2 January 21st 07 05:46 AM
Use values instead of labels on X-axis in Area/Stacked Area Charts Ryan Charts and Charting in Excel 1 November 21st 06 04:14 PM
Setting source data range with Charts D Charts and Charting in Excel 2 January 1st 06 02:51 AM
Gridlines on Area/Stacked Area charts AgileDarrell Charts and Charting in Excel 1 August 6th 05 12:04 AM


All times are GMT +1. The time now is 01:51 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017