+ Reply to Thread
Results 1 to 3 of 3

Hiding Series for Total Values/Percentages

  1. #1
    Forum Contributor
    Join Date
    03-09-2014
    Location
    Telford
    MS-Off Ver
    Microsoft 365
    Posts
    101

    Hiding Series for Total Values/Percentages

    Hi All, Is possible to hide the series of value Totals or 100% as in percentage values in a chart with the Data Table still showing the values? I want to show the total percentages in the Data Table in the attached chart, however I don't want to show the series in the chart area. Any ideas? Many thanks
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Hiding Series for Total Values/Percentages

    You included too much data when you built the chart. To "rescue" it do the following.

    Right click on the chart and select Select Data. This will bring up a dialog box.

    On the right side are the series. Select a series and select Edit. This will show the range of cells that the series contains. In your example it goes through row 10. Change the 10 to 9.

    Do the same with the other two series.

    You won't have to do anything with the X-Axis, but you can edit it too to be sure.

    You now know how to "work under the hood" with charts. Sometimes they do need tweaking like this.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    03-09-2014
    Location
    Telford
    MS-Off Ver
    Microsoft 365
    Posts
    101

    Re: Hiding Series for Total Values/Percentages

    Thanks dflak. This works perfect.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate total using percentages
    By JustinDomino in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-03-2017, 12:02 PM
  2. [SOLVED] Pivot Table Sub-Total and Total Settings for Percentages
    By Adam Schaefer in forum Excel General
    Replies: 3
    Last Post: 04-21-2016, 09:50 AM
  3. Replies: 3
    Last Post: 09-27-2015, 03:29 PM
  4. Calculating total dollars and percentages by job
    By filly_05 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-13-2013, 02:24 PM
  5. Comparing Values as Total and O/u Percentages
    By rseijo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2013, 05:05 PM
  6. [SOLVED] Removing (Hiding) 1 of 4 Pivot Table Sub Total Values
    By Moosehead in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-07-2012, 02:06 PM
  7. [SOLVED] Hiding a total until all values are filled
    By DCZ in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-27-2006, 07:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1