Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text above bars in chart
Hi,
Text that you usally have to the left of a bar chart, I'm trying to put above each bar instead. Visit the link below for a view of what I mean, and to get example numbers. http://www.mikla.nu/chartbars/chartbars.htm Best Regards /Magnus |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text above bars in chart
Hi,
The first problem you are going to have is that data labels will not display that amount of text in a single line. Instead you will need to add text boxes. So, unless you do it all manually, you will have to use vba. I have some code for replacing Axis label which you maybe able to adapt. http://www.andypope.info/vba/Axislabel_textboxes.htm If you add a row between each of your statements and stagger the rows text and values it should work, with a little alteration to the position of the textbox. I would suggest using a 2d rather than 3d chart and trying to short the statements. Cheers Andy Magnus wrote: Hi, Text that you usally have to the left of a bar chart, I'm trying to put above each bar instead. Visit the link below for a view of what I mean, and to get example numbers. http://www.mikla.nu/chartbars/chartbars.htm Best Regards /Magnus -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text above bars in chart
Thank you Andy,
Well, using vba feels a little bit overkill for the users that wants this behavior. Is there any way to get the text above each bar even if it will be wrapped or truncated? Regards Magnus "Andy Pope" wrote in message ... Hi, The first problem you are going to have is that data labels will not display that amount of text in a single line. Instead you will need to add text boxes. So, unless you do it all manually, you will have to use vba. I have some code for replacing Axis label which you maybe able to adapt. http://www.andypope.info/vba/Axislabel_textboxes.htm If you add a row between each of your statements and stagger the rows text and values it should work, with a little alteration to the position of the textbox. I would suggest using a 2d rather than 3d chart and trying to short the statements. Cheers Andy Magnus wrote: Hi, Text that you usally have to the left of a bar chart, I'm trying to put above each bar instead. Visit the link below for a view of what I mean, and to get example numbers. http://www.mikla.nu/chartbars/chartbars.htm Best Regards /Magnus -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text above bars in chart
Hi,
Yes, as I said stagger your data and labels along with a dummy series. Assuming your test data was in the range A1:E11 what you need to do is insert a row between each data row, expanding it to A1:E20. No insert a cell above the axis labels so they appear in A3:A21. Add a set of data to column F with the label Dummy. The value being 100% and populate the cells on the same rows as the axis labels. In order to stop Excel incorrectly guessing your data add a space to the currently empty cell A2. Now select the range A1:F21 and create stacked bar chart. Apply data labels to the Dummy series display category name. Format the series to have no fill or border. Delete the category axis. You should now have double spaced stack bars with text in the middle, but as I said that amount of text will not look pretty in a data label. Cheers Andy Magnus wrote: Thank you Andy, Well, using vba feels a little bit overkill for the users that wants this behavior. Is there any way to get the text above each bar even if it will be wrapped or truncated? Regards Magnus "Andy Pope" wrote in message ... Hi, The first problem you are going to have is that data labels will not display that amount of text in a single line. Instead you will need to add text boxes. So, unless you do it all manually, you will have to use vba. I have some code for replacing Axis label which you maybe able to adapt. http://www.andypope.info/vba/Axislabel_textboxes.htm If you add a row between each of your statements and stagger the rows text and values it should work, with a little alteration to the position of the textbox. I would suggest using a 2d rather than 3d chart and trying to short the statements. Cheers Andy Magnus wrote: Hi, Text that you usally have to the left of a bar chart, I'm trying to put above each bar instead. Visit the link below for a view of what I mean, and to get example numbers. http://www.mikla.nu/chartbars/chartbars.htm Best Regards /Magnus -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to enter text inside the bars on a bar chart in Excel? | Charts and Charting in Excel | |||
how do I get more than 19 bars on a bar chart | Charts and Charting in Excel | |||
Help with bars in bar chart | Charts and Charting in Excel | |||
Up/down Bars - Line Chart | Charts and Charting in Excel | |||
Bars in a chart??????? | Excel Worksheet Functions |