Charts (Excel 2000)

Topic

New Reply

If I have a sales goal of $10,000 and my actual sales are at $5000, how would I get a 3-D bar chart to shade in the bar to the $5000 line instead of adding it to the to of the bar? Kind of like a progress chart.

Thanks!

Reply | Quote

Replies

You could add a calculated value Goal – Actual, and create a stacked bar chart from Actual and Goal – Actual. See attached.

Reply | Quote

Create a separate data series for Actual and Goal.

Right click on the Goal column. Under “Format Data Series”, assign Goal to the secondary Y axis. I’ve also adjusted the width of the Goal column by adjusting the “Gap Width”.

Make sure your secondary y axis has the same scale as your primary y axis.

See attached example.

Reply | Quote

Create a separate data series for Actual and Goal.

Right click on the Goal column. Under “Format Data Series”, assign Goal to the secondary Y axis. I’ve also adjusted the width of the Goal column by adjusting the “Gap Width”.

Make sure your secondary y axis has the same scale as your primary y axis.

See attached example.

Reply | Quote