Data labels in Chart

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.
 
L

Laura

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.
 

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

ASK Field Formatting 1
Re-title multiple MS Project .mpp files at once 0
Stacked Bar Chart 1
Bar Chart with Data Elements 1
Weighted % Complete calculation 1
Excel 2003 - Chart Data Label positions 1
Adding Baseline1 and Baseline2 on Gantt Chart View 0
Percentages AND Value lables on Stacked Columns 1

Top