Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data labels in Chart
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. |
#2
|
|||
|
|||
Nevermind, I just figured it out!
I clicked the data label on the chart, then put the formula in the formula bar, and, voila. "Laura" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stock High-Low-Close Chart | Charts and Charting in Excel | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How do I get my data labels on a pivot chart to retain their form. | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |