+ Reply to Thread
Results 1 to 6 of 6

High-Low lines on Clustered and Stacked column chart combined

  1. #1
    Registered User
    Join Date
    08-16-2022
    Location
    S?o Paulo
    MS-Off Ver
    365
    Posts
    3

    High-Low lines on Clustered and Stacked column chart combined

    Please, could someone help me to fix the high-low lines so that it is over the Clustered Column Chart and not over the Stacked Column?

    The lines are referent to the minimum and maximum values of the "Irrigation Recommendation with Deficit at Maturation" variable. To do that, I used the High-Low lines conecting the maximum and the minimum value of each month. However, those lines are over the Sticked Column Chart (Brown and Green) referent to "User-applied irrigation blade (WATER SOURCE water and REUSE water)" instead of being over the Clustered Chart (orange) ("Irrigation Recommendation with Deficit at Maturation -AVERAGE"). For a person who will see the chart will thing that those lines refere to the variables associated to the Sticked Column Chart, but they are referent to the variable associated to the Clustered Chart.
    Those lines are not referred to error bars.

    High and Low line on Clustered and Stacked column chart combined.xlsx

    I have the limitation that it needs to work on Office 2016 and it does not use VBA.

    Clustered and Stacked column chart combined.png
    Last edited by fhc92; 08-17-2022 at 09:52 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: High-Low lines on Clustered and Stacked column chart combined

    Hard to tell exactly how you have created you chart from a picture but if you want control over the hi low lines you could use custom error bars on a dummy xy-scatter series.

    Using xy-scatter will give you the ability to position along the horizontal axis, which is likely to be off center of each category cluster of columns.
    The custom values for the error bars allow you to control the length of each line.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-16-2022
    Location
    S?o Paulo
    MS-Off Ver
    365
    Posts
    3

    Red face Re: High-Low lines on Clustered and Stacked column chart combined

    Thank you so much, Andy!

    Didn't know about the xy-scatter possibility to do that.

    I had had posted the .xlsx document by the time I posted the thread.
    it is named: "Clustered and Stacked column chart combined", it is a .xlsx file, and it is two lines above the image.
    Could you, please, check if it is working and give me any other insight?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: High-Low lines on Clustered and Stacked column chart combined

    The workbook contains a picture.

    Where is the actual chart?

  5. #5
    Registered User
    Join Date
    08-16-2022
    Location
    S?o Paulo
    MS-Off Ver
    365
    Posts
    3

    Re: High-Low lines on Clustered and Stacked column chart combined

    Just uploaded the version with the chart I built.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: High-Low lines on Clustered and Stacked column chart combined

    In the example I have put the required data below the chart.

    add a new series, primary axis and change to xy-scatter.
    Add error bars. Remove X Error bars.
    Format error bars, Specify custom values and use Plus values.
    Attached Files Attached Files

+ 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. [SOLVED] Stuck, Stacked Clustered Column Chart
    By tonym33 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-22-2020, 09:53 AM
  2. Stacked clustered column chart
    By jpmoglia in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-14-2017, 09:58 PM
  3. How to make a clustered column stacked bar chart?
    By Jumana Nooruddin in forum Excel General
    Replies: 1
    Last Post: 11-11-2014, 09:41 AM
  4. [SOLVED] Clustered and Stacked column in the same chart
    By bryan444 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-16-2013, 10:03 AM
  5. Clustered and Stacked Column Chart
    By superkid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-19-2009, 09:54 AM
  6. [SOLVED] Combined: Clustered-Stacked Column Chart
    By cdo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-30-2005, 09:05 PM
  7. [SOLVED] Combined Clustered and Stacked Chart
    By Alison in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-02-2005, 02: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