+ Reply to Thread
Results 1 to 4 of 4

Remove some numbers from a graph

  1. #1
    Registered User
    Join Date
    04-15-2016
    Location
    Oslo
    MS-Off Ver
    Excel 2013
    Posts
    79

    Remove some numbers from a graph

    How can I remove the numbers that I have circles with a red marker in this graph? I don't think they need to be displayed.
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Remove some numbers from a graph

    Can you please upload an Excel workbook as it will make finding a solution easier.

    I have assumed the circled numbers relate to the axis titles. In 2016 this can be removed by clicking the X near the top of the chart and changing the settings in Chart elements. It may be a little different in Excel 2013. On an uploaded version I might be able to be more specific.

    Cheers

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,923

    Re: Remove some numbers from a graph

    I'm not sure you can hide the header row of a chart data table. You might be stuck with them.

    BSB

  4. #4
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Remove some numbers from a graph

    Hi

    I have attached a version of a graph similar to yours created in Excel 2016.

    I have forgotten the actions for Excel 2013 but they could be similar if it helps.

    To create the chart I set up the table with headers 1 through 4 created the chart then deleted the row of headers.
    Excel 2016 allows modification of "Chart Elements" and changing the Horizontal axis data and also allows adding the data plotted table.
    I am not sure whether 2013 has the same facility.
    I know this sounds a bit vague but it may point you in the right direction.

    Cheers
    Attached Files Attached Files

+ 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. Replies: 8
    Last Post: 11-19-2014, 06:12 PM
  2. Remove zero values in a graph
    By cercle92 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-10-2014, 11:36 AM
  3. remove unused legend values from graph
    By davyre in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2013, 05:15 AM
  4. [SOLVED] [SOLVED] Macro/Wildcard to remove only numbers excluding text with numbers
    By indianhp in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2013, 08:16 AM
  5. [SOLVED] Help! Remove numbers and all chars to left of the numbers.
    By trouble085 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2012, 09:54 PM
  6. Remove #N/A data from graph
    By cokee33 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-05-2008, 10:11 AM
  7. [SOLVED] Can I remove just one title within a graph legend and not hide th.
    By KLF in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-07-2005, 03:05 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