Results 1 to 6 of 6

Changing chart type & second axis on chart with 2-level axis labels

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-04-2015
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2010
    Posts
    114

    Changing chart type & second axis on chart with 2-level axis labels

    Example is attached.

    I created a simple bar chart with 2-level axis labels. It is the number of aircraft per month; grouped by aircraft type.

    I want to add a sixth group with the total. The total is a much higher number and due to scale it distorts interpretation of the other groups (i.e. the aircraft type).

    So, I want to:
    1. Add the total number of aircraft per month as an additional group
    2. Plot these values on a secondary axis so as not to distort the scale
    3. Consider changing the chart type to a line graph; just to see if it is visually more appealing

    As a bonus question: Can one easily change the colors of the groups (i.e. the aircraft types)? All columns were blue when I created the chart and I have to select each column and change the color individually.

    It's the first two-level chart I've made...pretty cool
    Attached Files Attached Files
    Last edited by trolle; 04-14-2016 at 04:34 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Scatter chart x axis labels not changing to appropriate values
    By Vbot in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-14-2014, 10:54 PM
  2. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  3. Changing colour of bar chart, whilst keeping the labels on x-axis
    By trueng in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-16-2013, 06:05 AM
  4. Changing chart axis labels
    By jshaw82 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 01-21-2013, 05:08 AM
  5. Hangup/crash after changing chart axis type, help!
    By flipdac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2011, 08:47 AM
  6. Hangup/crash after changing chart axis type
    By flipdac in forum Excel General
    Replies: 0
    Last Post: 07-06-2011, 08:13 AM
  7. [SOLVED] 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

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