+ Reply to Thread
Results 1 to 3 of 3

Combining axis labels

  1. #1
    Registered User
    Join Date
    12-21-2020
    Location
    San Diego, CA
    MS-Off Ver
    MS 2016
    Posts
    1

    Combining axis labels

    Hello,

    I am hoping there is a simple fix. I am tracking personal finances and would like to create a bar chart showing amount spent on each category. Multiple expenses are showing as individual axis labels instead of combining like values. How would i combine categories to show Utilities as one line for example?

    Capture.PNG

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

    Re: Combining axis labels

    I think you are looking for the concept of a "multi-level category axis" (which is mostly about how you arrange the data in the spreadsheet and how you define the category axis label range). See if this helps: https://exceljet.net/lessons/how-to-...lti-level-axis
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Combining axis labels

    Sounds like you want the chart to aggregate data based on category name. Only way to do that automatically is to use a pivot table/chart.
    You could use formula if you know what all the possible unique categories are.
    Cheers
    Andy
    www.andypope.info

+ 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. Overlay data labels over axis tickmark labels
    By zealot in forum Excel General
    Replies: 1
    Last Post: 11-11-2020, 03:39 AM
  2. Line graph with 2 y-axis not showing correct x-axis labels
    By TheRobsterUK in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2020, 12:15 PM
  3. Changing chart type & second axis on chart with 2-level axis labels
    By trolle in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-15-2016, 09:52 AM
  4. [SOLVED] Need graph to show alphanumeric values as Y axis labels with Date as Z axis labels
    By Ochimus in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2015, 08:40 PM
  5. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  6. Changing individual axis labels on the same axis (vba?)
    By sikey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-07-2010, 06:08 AM
  7. how to put x axis values in the chart instead of x axis labels
    By Sinclair in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-21-2005, 06:05 AM

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