Results 1 to 4 of 4

Overlapping Series in Cluster Chart?

Threaded View

  1. #1
    Registered User
    Join Date
    08-08-2022
    Location
    New York, NY
    MS-Off Ver
    2102
    Posts
    4

    Overlapping Series in Cluster Chart?

    Hi - I have a question which I am sure as a workable solution, but I am struggling to figure it out. I currently have the attached stacked cluster chart (that dual axis is a separate counter from the $ values in the bars themselves - that line can be ignored).

    The way I currently have it set up is a stacked column chart where I am essentially breaking it up into "parts" with the assumption that the light blue value will always be the highest, followed by the middle blue, followed by the dark blue (meaning this dark blue is always the lowest).

    This assumptions works now, but it is possible that down the line the middle blue might actually be higher than the lightest blue. As a result, I want to figure out a way to overlap the series in a regular cluster chart, but somehow set it up in a way so that the smallest value will dynamically appear at the front, followed by the second smallest, followed by the last and largest number (which will "peak out" above the other two. Of course, this would mean using the "actual" item values, rather than breaking it up into pieces as I currently have it set up.

    I am familiar with overlapping series, but is there a way to set a "priority" of which of the values should show the front most (which I always want to be the smallest value, and progressively up from there).

    I hope that all was explained clearly, and if not, of course happy to rephrase or send additional attachments.

    Cheers!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 08-08-2022, 05:35 PM
  2. Excel chart datapoint values on hover - overlapping series
    By Excelcb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-10-2022, 09:25 AM
  3. VBA code to move shape on overlapping bar chart to the end of the data series
    By som3on3_10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2014, 12:59 PM
  4. Stacking a single series in a cluster bar chart
    By Bull Run in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-10-2014, 04:32 PM
  5. Replies: 2
    Last Post: 10-25-2013, 10:22 AM
  6. Replies: 4
    Last Post: 01-02-2012, 04:52 PM
  7. Replies: 3
    Last Post: 12-29-2010, 06:43 AM

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