Marmot3292
New Member
- Joined
- Apr 5, 2019
- Messages
- 20
Afternoon,
I am struggling to overlay a horizontal stacked bar chart I have created that already shows max and min ranges, and a break for the average values, with markers that represent a current value. I managed to do this in older versions of Excel by adding a new series, changing that series to a line chart with markers and then making the line transparent however I can't figure it out in the new Excel.
Please can someone help me
Below is my data - columns H - M show the data I am plotting. In the chart below, I have changed the fill for the 'Minimum' column to be transparent, then the average - minimum value is shown in orange, and then maximum value - average is shown in blue. I want to add a dot or marker to now represent the 'current value' in column M, to show where we are in the range and whether that is above or below average.
Chart:
Can anyone help me with the steps?
Many thanks
I am struggling to overlay a horizontal stacked bar chart I have created that already shows max and min ranges, and a break for the average values, with markers that represent a current value. I managed to do this in older versions of Excel by adding a new series, changing that series to a line chart with markers and then making the line transparent however I can't figure it out in the new Excel.
Please can someone help me
Below is my data - columns H - M show the data I am plotting. In the chart below, I have changed the fill for the 'Minimum' column to be transparent, then the average - minimum value is shown in orange, and then maximum value - average is shown in blue. I want to add a dot or marker to now represent the 'current value' in column M, to show where we are in the range and whether that is above or below average.
Chart:
Can anyone help me with the steps?
Many thanks