Fri 20 Mar 2009, 16:59Delegate John said...
John has attended:
Excel Intermediate course
Charts
On a line chart how do you get data not to show?
ie if you have data for last year which you want to show in total but only have this years to date how do you stop this years data showing a line down to the base of the chart at todays date?
Fri 27 Mar 2009, 15:47Trainer Andrew said...
RE: Charts
Hi John
Thank you for your question. If I understand you correctly you might want to remove the series of data for the current (incomplete) year.
Click on your chart. From the chart menu choose Source Data then click on series. You can add remove or edit your data series here. This controls what is included in the chart.
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew
