Jyggalag

Active Member
Joined
Mar 8, 2021
Messages
422
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi all,

I currently have this graph here:

1663228693277.png


I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know:

1) is this possible, and if so, how?
2) if it is possible, is it also possible to make it do this coloring without pasting the orange color over the white line inbetween the graphs?

I would truly appreciate some assistance here, as I have basic to none experience in terms of excel graphs :)

Thank you all!
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
I have done this before by adding two helper columns to the data and adding two more series in the graph.

Add a column to your data named: Base - Make this column be the lower values of the parallel line.
Add a column to your data named: Difference - Make this column be the difference between the upper and lower values of the parallel line.
Right click o your graph and select: Select data
Click on the: 'Add' button to add a series
Add the: 'Base' column to the 'Legend Entries'
Click on the: 'Add' button to add a series
Add the: 'Difference' column to the 'Legend Entries'
Click: OK
Right click one of the lines on the graph and select: Change Series Chart Type
Set: 'Base' to be a stacked area
Set: 'Difference' to be a stacked area
Click: OK
Now right click on the area under the lower line and set 'Fill' to 'none'
You can delete the 'Base' and 'Difference' from the legend on the graph if you wish

Main HeadMain ValLower ValUpper ValBaseDifference
19078987820
292821028220
38876967620
48774947420
58173937320
68370907020
77065856520
87970907020
98574947420
108078987820
 
Last edited:
Upvote 0
Solution
I have done this before by adding two helper columns to the data and adding two more series in the graph.

Add a column to your data named: Base - Make this column be the lower values of the parallel line.
Add a column to your data named: Difference - Make this column be the difference between the upper and lower values of the parallel line.
Right click o your graph and select: Select data
Click on the: 'Add' button to add a series
Add the: 'Base' column to the 'Legend Entries'
Click on the: 'Add' button to add a series
Add the: 'Difference' column to the 'Legend Entries'
Click: OK
Right click one of the lines on the graph and select: Change Series Chart Type
Set: 'Base' to be a stacked area
Set: 'Difference' to be a stacked area
Click: OK
Now right click on the area under the lower line and set 'Fill' to 'none'
You can delete the 'Base' and 'Difference' from the legend on the graph if you wish

Main HeadMain ValLower ValUpper ValBaseDifference
19078987820
292821028220
38876967620
48774947420
58173937320
68370907020
77065856520
87970907020
98574947420
108078987820
This works. Absolutely amazing, thank you so much Sir.! :)
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,316
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top