Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Labels on a chart
I have a Column Chart where I am charting values in column E. E2 contains
the results of =C2/D2, E3 contains the results of = C3/D3, etc. These values are displayed above each of the columns in the chart. What I need to do is also display the value contained in C2 below the column repersenting the result of =c2/D2, I need the value in C3 below the column representing the result of =C3/D3, and so on. How can I get this accomplished? Thank you very much for any insight. |
#2
|
|||
|
|||
Hi Kevin,
If you can live with the values of columns C and D being positioned just within the plotarea above the x axis then you could just plot all 3 series in one chart. Create a normal clustered column chart based on the rows for columns C:E. Format the 1st and second series to be on the secondary axis. Adjust the gap width of the 3rd series so it is as width as the 2 columns. Now apply data labels to the 1st 2 series and align the data labels to Inside Base. Or you could just use a helper column to build the display text and use this as the category labels. Try a formula like this in F2 and then copy down. F2: ="("&C2&","&D2&")" Cheers Andy Kevin wrote: I have a Column Chart where I am charting values in column E. E2 contains the results of =C2/D2, E3 contains the results of = C3/D3, etc. These values are displayed above each of the columns in the chart. What I need to do is also display the value contained in C2 below the column repersenting the result of =c2/D2, I need the value in C3 below the column representing the result of =C3/D3, and so on. How can I get this accomplished? Thank you very much for any insight. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pie Chart Data Labels | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |