Results 1 to 4 of 4

How to change the horizontal axis and legend in a bar chart?

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2019
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    2

    How to change the horizontal axis and legend in a bar chart?

    Good day everyone!

    I have been puzzeling for hours on how to change the horizontal axis on my bar chart. Currently it is automatically labelling them with 1,2,3,4,5. However, I need them to be labeled (i) (ii) (iii) (iv) (v) AND then I need the legend to also show (i), (ii), etc... I've already tried it with Format Axis and with changing the descriptions under Select Data... However, under format axis it changes all the labels to the same name and under select data I get the same issue. Can somebody help me?

    Kind regards,
    Ivy
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How change vertical alignment of dates in horizontal axis of chart?
    By fidgetyFingers in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-09-2018, 03:14 AM
  2. [SOLVED] create x-axis and a y-axis chart as an image horizontal and vertical values
    By Khaldon in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 10-11-2018, 09:12 AM
  3. Replies: 1
    Last Post: 03-01-2014, 07:10 AM
  4. change to chart primary horizontal axis label or name
    By pwynkoop in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 04-10-2013, 01:30 AM
  5. Replies: 1
    Last Post: 12-12-2012, 10:50 PM
  6. Legend Only Shows Used Axis on Dynamic Chart (X, Y and Y2 axis)
    By TEBrown in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-21-2012, 10:15 AM
  7. Replies: 1
    Last Post: 09-02-2011, 08:57 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