Excel Chart XY Scatter

Topic

New Reply

Is there a way in Excel to fill rectangles from 0 to each XY intersection point?

Reply | Quote

Replies

The rectangles would overlap. How would you want to handle that?

Reply | Quote

The rectangles would overlap. How would you want to handle that?

I’ve manually drawn in the fill areas on the attached file. Only the incremental NPV would be displayed as the fill area.

Reply | Quote

I don’t know how to do this in an XY scatter chart.

The attached workbook was created from Funchrt5.xls by Stephen Bullen, available from Office Automation Ltd. – Stephen Bullen’s Excel Page.

It uses named ranges to define the data for an area chart.

Reply | Quote

I don’t know how to do this in an XY scatter chart.

The attached workbook was created from Funchrt5.xls by Stephen Bullen, available from Office Automation Ltd. – Stephen Bullen’s Excel Page.

It uses named ranges to define the data for an area chart.

This chart does exactly what I was looking for. Thank you for the resource link.

Reply | Quote