How do you get a chart to show only data up to today's date automatically? My data range has the the entire year in it but only up to today's date has actual numbers. My data has formulas linking it to other daily reports so, anything after today show's up as a zero value.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Chart data
- Thread starter Tmoske
- Start date
VoG
Legend
- Joined
- Jun 19, 2002
- Messages
- 63,650
This may help http://peltiertech.com/WordPress/dynamic-charts/
Upvote
0
I don't really have THE solution to your problem, but do have a suggestion on how to get your chart from showing a zero value after the present date.
Lets say your data series is in column B, go to an unused column on the spreadsheet, let's say column R and type in: =if(B1<1,NA(),B1), fill this in down the column. Now, go to your chart and change the data series from reading column B to reading column R.
Blank or 0 cells will no longer be picked up by the chart.
Lets say your data series is in column B, go to an unused column on the spreadsheet, let's say column R and type in: =if(B1<1,NA(),B1), fill this in down the column. Now, go to your chart and change the data series from reading column B to reading column R.
Blank or 0 cells will no longer be picked up by the chart.
Upvote
0
Similar threads
