Data labels in Chart

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

Hi,

I have a bar chart that shows projected and actual numbers for four quarters.

I'd like to label each pair of bars with the PERCENTAGE between the projected and actual numbers for each quarter, rather than the actual number each bar represents.

Is there a way to do this based on a formula? (As opposed to creating text boxes and insertng them?)

Thanks so much.
 
Nevermind, I just figured it out!

I clicked the data label on the chart, then put the formula in the formula bar, and, voila.
Hi,

I have a bar chart that shows projected and actual numbers for four quarters.

I'd like to label each pair of bars with the PERCENTAGE between the projected and actual numbers for each quarter, rather than the actual number each bar represents.

Is there a way to do this based on a formula? (As opposed to creating text boxes and insertng them?)

Thanks so much.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Changing chart label colors based on a value in a cell 0
Data Labels Disappearing 0
Label a Percentage Bar with Value 3
Percentages AND Value lables on Stacked Columns 1
Stacked Bar Chart 1
Stacked Charts 4
IF formula statement that would spread an annual budget over 12months 1
PowerPoint Embed scroll excel chart and data in powerpoint 0

Back
Top