I am trying to create an area chart to show the range of margins over the last five years. However, my min series has positive and negative values, so Excel wants to color the area under the positive values in the lower range (the grey values for May and June under the line). Any idea how to get excel not to color that area?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Trying to create an area range chart where the lower bound has both positive and negative numbers.
- Thread starter torealden
- Start date
Excel Facts
Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Similar threads
- Question
- Replies
- 0
- Views
- 634
- Replies
- 0
- Views
- 2K
- Replies
- 0
- Views
- 206
- Question
- Replies
- 0
- Views
- 334
- Replies
- 0
- Views
- 453
