Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting subset of time value data
Hey all, I just upgraded from Excel 2003 to 2007 and one of my graphs stopped
working properly. I have a data set with date ranges from 2001 to 2025 and several series. Some of the series have data out to 2025 and some only to the current date. I plot the data in various ways but when I try to plot from2001 to date only, I get all the data plotted out to 2025 with the axis only labeled from 2001 to 2009 for the first 1/3 of the axis or so. In 2003 when I selected a subset of the date range it would plot just the dates I asked for over the full axis but 2007 is plotting all the data no matter what range I select and just adjusting which labels it prints. If I change to text axis then I cannot select a subset as far as I can tell. Can someone help me out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting in Real-Time | Excel Worksheet Functions | |||
Subset of table data on another worksheet | Excel Discussion (Misc queries) | |||
How do I create a new worksheet for a subset of data | Excel Discussion (Misc queries) | |||
How to enter symbols for subset or element of a subset in Excel? | Excel Worksheet Functions | |||
plotting time | Charts and Charting in Excel |