Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
MOVING DATE RANGE ON A CHART
I currently have a static chart that shows a range of six months at a time.
Every so often I have to go in and change the source data to not only accomodate for more recent past data, but to also account for future data (which is blank). This means that 1/4 of my graph shows no data. Is there a way to have your chart only show data in exactly a six month interval without having to manually update the source data in the chart? -- Drew |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
MOVING DATE RANGE ON A CHART
You can define dynamic ranges in the sheet, and chart these. This example
shows the last 12 months: http://peltiertech.com/Excel/Charts/DynamicLast12.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Drew" wrote in message ... I currently have a static chart that shows a range of six months at a time. Every so often I have to go in and change the source data to not only accomodate for more recent past data, but to also account for future data (which is blank). This means that 1/4 of my graph shows no data. Is there a way to have your chart only show data in exactly a six month interval without having to manually update the source data in the chart? -- Drew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Data Range in Chart | Charts and Charting in Excel | |||
How to add data outside chart range | Charts and Charting in Excel | |||
Return a specified date when it falls within a range.... | Excel Discussion (Misc queries) | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |