+ Reply to Thread
Results 1 to 3 of 3

Create Additional Category Axis Labels

  1. #1
    Registered User
    Join Date
    06-25-2017
    Location
    Wasahington, DC
    MS-Off Ver
    2013
    Posts
    1

    Create Additional Category Axis Labels

    Hello,

    I have created a report and bar chart (I was specifically asked to create a bar chart) that reflects income per month for Jan 2000-present for my organization that I will use in a PowerPoint slide, so the size of the chart is becoming a bit of an issue. What I would like to do is create another set of category labels that would span each year under the corresponding months. Is there any way to have Excel do that? What would be the best way to do that?

    Thank you for your help!

    patriziasue

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Create Additional Category Axis Labels

    Hello patriziasue and Welcome to Excel Forum.
    I don't know the set up your using, however if you have two columns, date and income, then add two more, month and year.
    The Month column is populated by the formula: =A2 and custom formatted: mmm
    The Year column is populated by the formula: =IF(MONTH(A2)=1,YEAR(A2),"") and formatted: general
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    06-28-2017
    Location
    uk
    MS-Off Ver
    2013
    Posts
    15

    Re: Create Additional Category Axis Labels

    if you create a Pivot chart rather than a standard chart then you can add multiple sets of criteria to each axis.
    Last edited by AliGW; 06-29-2017 at 03:47 AM. Reason: Promotional link removed by moderator.

+ 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. Category labels on X-axis of a scatterplot
    By tjohnpok in forum Excel General
    Replies: 1
    Last Post: 04-04-2016, 11:56 AM
  2. Help with Plotting data Axis Category labels
    By Troutner in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-24-2013, 11:53 AM
  3. Category x axis labels not displaying
    By tezread in forum Excel General
    Replies: 12
    Last Post: 10-21-2010, 06:30 AM
  4. Change of Category (X) axis labels
    By patejl in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-18-2008, 07:02 PM
  5. Category Labels(X) axis on a chart:
    By Ali in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-19-2006, 07:55 AM
  6. alignment of y axis category labels
    By philcud in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-09-2005, 03:05 PM
  7. [SOLVED] Bar chart & Category (x) axis labels
    By Airi A. in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-15-2005, 12:06 PM

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