+ Reply to Thread
Results 1 to 4 of 4

Column chart with two different data ranges

  1. #1
    Registered User
    Join Date
    11-30-2020
    Location
    paris
    MS-Off Ver
    16.43
    Posts
    4

    Column chart with two different data ranges

    Hello!

    I wonder if it's possible to create one comparison chart with two very different data ranges.

    For example quantities of sold products compared to the net sales value.
    These numbers go in very different ranges (for example quantity can be 2, whereas net sales value might be 500), so a regular comparison chart doesn't work, since the value 2 is compared to 500 which doesn't make sense here.

    Not sure if it's possible somehow to have the max value of the chart on one side set as max value of net sales, and on the other side as max value of quantities..?

    What I would need, is to compare all the quantities of different products to each other, and all the net sales to each other, but also to have the quantity and net sale of each product in a graph. Attaching the example file. Basically, I would like to have both of the different charts (blue = quantities, orange = net sales) to visually look similar within the same graph.

    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2013; 365
    Posts
    221

    Re: Column chart with two different data ranges

    It is possible by setting a secondary axis for 1 of the ranges, by going to Chart Design - Change Chart Type - Combo - then adding a check in the Secondary Axis column for 1 of the 2 Series.

    See attached for an example.
    Attached Files Attached Files
    To show your appreciation
    Click ★ Add reputation!

  3. #3
    Registered User
    Join Date
    11-30-2020
    Location
    paris
    MS-Off Ver
    16.43
    Posts
    4

    Re: Column chart with two different data ranges

    amazing, thank you Mrrrr

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: Column chart with two different data ranges

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Problems creating a bar or column chart based on dynamic offset ranges
    By chrisk67 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-01-2016, 03:23 PM
  2. Column chart with variable data ranges
    By jarydmiles in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-18-2016, 11:17 AM
  3. Using cell references to construct data ranges in chart data selection
    By rmalliston in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-13-2016, 08:48 PM
  4. [SOLVED] Can I make the data ranges displayed in a chart vary depending on my no. of data points
    By David Myers in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-06-2014, 02:16 PM
  5. Selecting chart data ranges
    By Jonathan78 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-23-2010, 06:37 AM
  6. Replies: 16
    Last Post: 03-16-2010, 10:33 AM
  7. Combination chart with three data ranges
    By Joe Mac in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-11-2005, 06:05 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