| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you dynamically expand the time range to the series data added
I'm trying to create a chart for work. I have the chart with about ten years
of dates. A worker will fill in the data (byte count) as the Y-Axis data. The dates are the X-Axis data. I have the dates already filled in (from 1/1/2008-12/31/2029). My question is whether or not Excel can only show data with the dates that have data. I already have it connect when a data point it missing, but I want it to also not show the last 28 years, if I only have the first year of data filled in. I would rather not have to select new series data every day. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to dynamically change the series range of a chart ? | Charts and Charting in Excel | |||
| Use a macro to expand data series for chart? | Charts and Charting in Excel | |||
| Add a data series dynamically to a named range? | Charts and Charting in Excel | |||
| automatically expand chart data series as data is added | Charts and Charting in Excel | |||
| Data Range Will Not Expand | Excel Worksheet Functions | |||
Threaded Mode
