View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
name
 
Posts: n/a
Default chart with dynamic x axis


Is it possible to setup a chart of a time series so that the periods
charted can be defined by user inputs? For example, I have a chart of
sales for the entire year. There is an input for 'month to review'.
Even though I have sales for 12 months, if the user inputs 3 into this
field, I'd like the chart only to plot months 1-3. Any help is
appreciated.


--
name
------------------------------------------------------------------------
name's Profile: http://www.excelforum.com/member.php...o&userid=34115
View this thread: http://www.excelforum.com/showthread...hreadid=538861