+ Reply to Thread
Results 1 to 3 of 3

Changing category in Excel Chart

  1. #1
    Registered User
    Join Date
    02-21-2019
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    2

    Question Changing category in Excel Chart

    I have the following data and would like to generate a char for this. The values under Incident are names (or numbers) of the Incidents. Excel plots me a scattered graph for this by default but the value in x axis (incident numbers) is being treated as some range of numbers. I need the incident number as is (as a cateogry) in the x axis. how do I achieve this?graph.png

    Incident Time To Detect
    217994 3
    215214 1
    210502 36
    209530 3
    Medicare 3
    204489 57
    203386 24
    200470 56
    Last edited by sandy_0518; 02-21-2019 at 10:02 PM. Reason: changed formatting

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,810

    Re: Changing category in Excel Chart

    Hard to say from a picture, but my first thought is to use a line chart rather than a scatter chart. Try selecting the chart -> chart type -> change to line chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    02-21-2019
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    2

    Re: Changing category in Excel Chart

    Thanks a bunch. That worked. I tried everything else other than line previously.

+ 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. Excel pie chart - fix pie colour by category name
    By Frankximus3 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-18-2020, 05:05 PM
  2. Excel chart with multi level category label issue delinking source data from chart
    By babu324 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2017, 02:58 AM
  3. [SOLVED] Knowledge Check: Changing the Category Order on a Bar Chart
    By The_Snook in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-30-2016, 04:51 AM
  4. Changing a pivot chart column color based on the pivot table category
    By Shawne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2014, 09:12 AM
  5. Replies: 0
    Last Post: 04-09-2014, 04:21 PM
  6. How to Chart values for Division vs Category and Sub-Category?
    By rahulgk in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-11-2013, 06:33 AM
  7. Replies: 2
    Last Post: 09-14-2012, 04:31 AM

Tags for this Thread

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