98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts
Charts
Resolved · Low Priority · Version 2003
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
Fri 3 Apr 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Highlighting a data rangeAttempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own! |
