Results 1 to 6 of 6

High-Low lines on Clustered and Stacked column chart combined

Threaded View

  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.

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. 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