+ Reply to Thread
Results 1 to 6 of 6

High-Low lines on Clustered and Stacked column chart combined

Hybrid View

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

    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

  2. #2
    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?

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