+ Reply to Thread
Results 1 to 2 of 2

Column chart (clustered column) with multiple columns and in proportion values

  1. #1
    Registered User
    Join Date
    04-12-2021
    Location
    Perth Australia
    MS-Off Ver
    2016
    Posts
    3

    Column chart (clustered column) with multiple columns and in proportion values

    Hi,
    I have a raw data to create a chart to show a comparison each month for year 2019 and 2020 with multiple products.
    I have chosen a column chart (clustered chart or stacked chart).
    My problem is the product quantity is in proportion, the average of the product quantity is between 1 - 900 but one product has 13000 quantity.
    As a result, the chart does not look in proportion.
    I tried to work around the chart, adjusted the axis' format (being the quantity) from 0 - 13000 to only show from 0 - 1000 and also change the unit format.
    Then changed the chart to show the quantity on each bar but the ones above 1000 won't show the quantity because of the unit format that i adjusted.

    Please see attached for reference.

    can anyone help me how to visualize the best. thank you.
    Attached Files Attached Files
    Last edited by lydiat; 04-12-2021 at 11:41 PM.

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

    Re: Column chart (clustered column) with multiple columns and in proportion values

    After a couple of days, here's what I see. I see something that reminds me a lot of this tutorial: https://peltiertech.com/broken-y-axis-in-excel-chart/ You have one column that dwarfs all of the other columns so that it is difficult to see anything other than the one column. The solution proposed in this tutorial is a panel chart. Unfortunately, your chart is also a pivot chart which probably does not have the flexibility needed to have two copies of each data series in the chart source range. If you decide to pursue creating a panel chart, you will probably need to include the information from here (https://peltiertech.com/regular-char...-pivot-tables/ ) on how to make regular charts from pivot data.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Removing blank columns in clustered column chart
    By Pharmacisticus in forum Excel General
    Replies: 1
    Last Post: 05-07-2019, 10:30 AM
  2. Clustered Column Chart with multiple values
    By lovelyxxlush in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-25-2018, 08:45 AM
  3. [SOLVED] Clustered Stacked Column Chart - Adding New Columns
    By Seve in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2016, 04:00 AM
  4. Column width in a clustered column chart
    By Geza Laszlo in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-26-2016, 11:39 AM
  5. Replies: 3
    Last Post: 10-29-2015, 10:58 AM
  6. Plotting Multiple and Large Data sets on a clustered column chart
    By spuri78 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 01-01-2014, 09:14 AM
  7. Clustered Column Chart Help
    By LordMarcus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-19-2009, 12:23 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