Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,069
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default 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

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
sheet protection - only selected range to be able to select/input data Corey Excel Worksheet Functions 7 February 13th 07 05:41 PM
quickly select data to produce charts kim Charts and Charting in Excel 1 March 8th 06 04:12 AM
How do I select on two variables in a range of data in excel Jeff Excel Worksheet Functions 7 September 13th 05 01:10 AM
Select updated data from a range of columns Alylia Excel Worksheet Functions 5 August 30th 05 01:53 PM
Excel charts should let me select a range for data labels. Relmbo Charts and Charting in Excel 3 June 26th 05 02:33 PM


All times are GMT +1. The time now is 07:58 AM.

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"