How do I select 13 months from a data range for charts
 

the charts created contain up to 6 different data sets and I have been trying
to find a way to select only certain months to show

How do I select 13 months from a data range for charts
 

Have a look at Andy Pope's site http://www.andypope.info/charts/Scrolling.htm
tis might help
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"marg" wrote:

the charts created contain up to 6 different data sets and I have been trying
to find a way to select only certain months to show

How do I select 13 months from a data range for charts
 

Some ideas:

http://peltiertech.com/Excel/Charts/DynamicLast12.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=246

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"marg" wrote in message
...
the charts created contain up to 6 different data sets and I have been
trying
to find a way to select only certain months to show

How do I select 13 months from a data range for charts
 

Got the data bi but how do i insert the scroll bar

"marg" wrote:

the charts created contain up to 6 different data sets and I have been trying
to find a way to select only certain months to show