We help IT Professionals succeed at work.

How do I include Total in the Data Table but hide it in the graph

45 Views
Last Modified: 2017-03-22
I do not want to see the total data points in the line graph, bit I do want to see the Total values in the data table.  Please see attached for my example.

In my example I want to remove 9, 15, and 21 from the line graph, but see in the data table...
EE-Line-Chart.xlsx
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Right-click anywhere on the chart and select "Select Data". In "Chart data range", change ='Sheet1'!$A$1:$D$5 to ='Sheet1'!$A$1:$D$4, then click OK.
Finance Analyst
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
You will also need to delete the data labels for the Total Points as well. Click on a Data Label for the series and all are selected. Then click again on the one for the total and only that one will be selected. Press Delete key.

Then again the whole point of having the Data Table is to show the individual values so having Data labels as well is duplicating it.

Author

Commented:
Thanks !
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.