excel for mac 2016 how to put one bar behind another

Excel 2016 Put One Bar Behind Another Series He Compares

Why you say the numbers will be mixed They will not, to my understanding.

He came up with a very clever and rather effective bar chart to display his data.

Ive included a mere excerpt of Roberts chart below, enough to show the visual appearance of the chart.

Excel 2016 Put One Bar Behind Another Series He Compares

The two series he compares overlap, such that the shorter bar is in front and the longer bar extends further along the axis scale.

I thought about it for a moment, and realized he could use a clustered chart type with full overlap, and only one additional worksheet column and one extra chart series.

There are two sets of numbers (One and Two) for a half dozen categories.

This column has a data value matching that of series One if that value is less than the corresponding value of series Two; otherwise the value is zero.

This results in a second set of series One values that will plot in front of series Two when overlapped.

I found that the darker background selectively lightened the foreground bar colors, making it difficult to assess values close to 50.

For Roberts chart, showing election results, Id limit my vertical gridlines to 50 and 100.

Electoral Votes Using Stacked Bar Charts, in which he describes the mechanics of his stacked bar approach.

Format series One and One-A the same, then remove the One-A legend entry by clicking once to select the legend, then again to select the One-A legend label, then press Delete.

The result is visually indistinguishable from the chart just above this update.

I did think about keeping only the 50 and 100 lines, but I wanted to make it easier to read the numbers.

If you added a One-A bar for C you end up with a bullet type format that makes comparisoncomprehension much easier.

There is no One-A bar for C, because series One is greater than series Two for category C.

In some cases the chart is too cluttered, while in other cases, one series is emphasized at the expense of another.

Visualize one large width blue bar (but really 2 bars) overlayed with one small or medium width green bar.

When series two is less than one, it is simple and clear, IMO, but you need to add a one A for c.

What is interesting though, is where the electoral vote was less than the popular, so these things were meant to stand out (and thats why I spent so much effort on this, to make that point).

If they are independent, then yes, the shaded series pulls a bias that should not be there.

Then column Two would show actual achievement figure for the quarter.

If you mean one of the charts from the comments, well, you would run into the same problem of confusion over mixed annual and quarterly numbers.

I want the dark blue column (called One) to come in two colors one representing the quarterly figure, the other the rest of the total figure for the year (so that the total blueother color column height represents total budget for the year).

Excel For Mac 2016 How To Put One Bar Behind Another