Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding Secondary Value to Bar Graph
I have a bar graph where I want to label the X-axis with one set of
labels and then put a completely unrelated label inside each bar. I know that Excel can have multiple x-axis labels, but is there a way to have one label on the axis and one label inside the bars? Thanks. John |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding Secondary Value to Bar Graph
Hi,
Can you not use the data label for text inside the bars? Cheers Andy wrote: I have a bar graph where I want to label the X-axis with one set of labels and then put a completely unrelated label inside each bar. I know that Excel can have multiple x-axis labels, but is there a way to have one label on the axis and one label inside the bars? Thanks. John -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding Secondary Value to Bar Graph
I have one set of labels I want on the X-axis and then an unrelated set
of labels (which are not the values) that I want inside the bars. ex. (hard to put in text) Category labels: A B C D E y-values that are represented in the bars: 6 2 1 5 3 2 labels inside bars: apple bear crab dog elephant Is there a separate "data label" option than I am missing? Thanks. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding Secondary Value to Bar Graph
You can either use this free addin to link data labels to cells
http://www.appspro.com/Utilities/ChartLabeler.htm Or add a second set of data So with the data in A1:C5 A 6 apple B 2 bear C 1 crab D 5 dog E 3 elephant Create a column chart on range A1:B5. Now add a second series again using the data in B1:B5. Move this series to the secondary axis. Don't worry that that the columns cover each other as you need to format the secondary series to have no fill or border. Use the source data dialog to specify the range C1:C5 as the secondary axis labels. Now apply data labels to the second series and change alignment to inside base. You can delete the secondary y axis and the entry from the legend. Cheers Andy Apply data labels to the series wrote: I have one set of labels I want on the X-axis and then an unrelated set of labels (which are not the values) that I want inside the bars. ex. (hard to put in text) Category labels: A B C D E y-values that are represented in the bars: 6 2 1 5 3 2 labels inside bars: apple bear crab dog elephant Is there a separate "data label" option than I am missing? Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Horizontal line to a graph | Excel Discussion (Misc queries) | |||
create bar graph with two series and secondary y axis | Charts and Charting in Excel | |||
How do I set up secondary axis on bar graph. What do I highlight? | Charts and Charting in Excel | |||
How do I automatically update a graph after adding a data point | Charts and Charting in Excel | |||
adding data table with different data to a graph | Charts and Charting in Excel |