Thread: Red/Amber/Green Chart

Hi All,

I have attached a copy of my spreadsheet onto which I need a few additions.

1. I would like to add two vertical lines at the points of the G and A threshold i.e. 4 and 6. My colleague does this manually on his versions but I cannot be bothered to do this.

2. I do not want the chart to show info for any cells in column B that don't have a project name in. These cells contain "" if this makes a difference?

The information in column B updates from a data sheet in my actual workbook just so people are aware.

Thanks all in advance!
dvent

The datum lines can be added via 2 additional series plotted as xy-scatter.
Then use Error bars to draw the vertial lines.

As for skipping data that has no project name that is more complicated.

You either need to build another table of data for the chart
Or use autofilter to hide blank rows.

Add to data series via the Add button on the Source data dialog.
Change the chart type to xy-scatter for the 2 new series.
Use the source data dialog again to set the values
First new series
Name: BrandG
X: =sheet1!D3
Y: ={0}

Second new series
Name: Brand A
X: =sheet1!E3
Y: ={0}

Delete seconadry X axis
Set the secondary value axis to Max at 1
format each series to have Y Error bar with a value of 1
Format error bar to have no cap and colour as appropriate.
Format data markers to none