Bar Chart - Percentage for each month

Originally Posted by Cecil

I have a simple bar chart showing budgeted spend vs. actual spend by month within a year. So, two bars per month. I would like to show actual spend as a percentage of budgeted spend for each actual bar. How can I do that?

Hi,

Does that attached workbook work for you? Let me know if it doesn't.

Originally Posted by Cecil

I have a simple bar chart showing budgeted spend vs. actual spend by month within a year. So, two bars per month. I would like to show actual spend as a percentage of budgeted spend for each actual bar. How can I do that?

Hi,

Does that attached workbook work for you? Let me know if it doesn't.

Originally Posted by Cecil

I have a simple bar chart showing budgeted spend vs. actual spend by month within a year. So, two bars per month. I would like to show actual spend as a percentage of budgeted spend for each actual bar. How can I do that?

Hi,

Does that attached workbook work for you? Let me know if it doesn't.

Originally Posted by Cecil

I have a simple bar chart showing budgeted spend vs. actual spend by month within a year. So, two bars per month. I would like to show actual spend as a percentage of budgeted spend for each actual bar. How can I do that?

Hi,

Does that attached workbook work for you? Let me know if it doesn't.

Originally Posted by Cecil

I have a simple bar chart showing budgeted spend vs. actual spend by month within a year. So, two bars per month. I would like to show actual spend as a percentage of budgeted spend for each actual bar. How can I do that?

Hi,

Does that attached workbook work for you? Let me know if it doesn't.

Originally Posted by Cecil

Yes, very good. Thank you.

Glad it could help. Just FYI, the percentage text is 3rd series which is set to hidden.