+ Reply to Thread
Results 1 to 3 of 3

How to have an axis with "categories" in a bar chart ?

Hybrid View

  1. #1
    Registered User
    Join Date
    11-11-2016
    Location
    Brussels
    MS-Off Ver
    2013
    Posts
    2

    Re: How to have an axis with "categories" in a bar chart ?

    Thank you very much!!
    The article you sent me gave me the asnwer! It helped me find my own creative way out:

    super.jpg

    It was tricky with bars but i managed.

    I didn't even have to use Rob Bovey's XY Chart Labeler add-in.

    For those interested:

    The blue serie (the actual real score) has:
    - Plot series on: Primary Axis
    - Series overlap: 100% (doesn't matter)
    - Gap width: 146%
    - Data label contains: Value


    The colorful series (at the bottom of the chart) have:
    - Plot series on: Secondary Axis
    - Series overlap: 100%
    - Gap width: 0%
    - Data label contains: Series name

    Cheers and thanks again!
    Last edited by adri123; 11-12-2016 at 02:09 AM.

+ 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. Update all chart x axis in workbook according to a specific "master chart" VBA query
    By synchrotron in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 06:00 AM
  2. Removing the "%" sign on Excel chart axis
    By Exorcist1 in forum Excel General
    Replies: 1
    Last Post: 05-21-2014, 08:54 AM
  3. Replies: 0
    Last Post: 08-04-2013, 02:00 PM
  4. [SOLVED] Assign Categories for Time of Day: "Morning", "Afternoon", "Evening"
    By long_shanks in forum Excel General
    Replies: 3
    Last Post: 06-11-2013, 02:59 AM
  5. Replies: 0
    Last Post: 07-08-2011, 02:25 PM
  6. Replies: 1
    Last Post: 12-02-2005, 03:20 AM
  7. [SOLVED] "Broken" chart axis for data of different scales
    By Charlie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-27-2005, 08:06 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