Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can I realign all data labels in a chart at once
I need to change the alignment of data labels in my chart so that they are
vertical. Is there any way of applying this format to all the data labels at once as everytime I alter the source data in the chart, the labels change back to horizontal alignment and I have to manually change the label format. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can I realign all data labels in a chart at once
Hi,
You can align all of the labels in a series at once. But you need to do each series individually. Depending on xl version you can do it once and the use the F4 key to repeat the action when the next series is selected. This single line of code in the immediate window will do all series. for i =1 to activechart.SeriesCollection.count:activechart.Ser iesCollection(i).datalabels.Orientation = xlTickLabelOrientationVertical:next i Cheers Andy Bumblebasher wrote: I need to change the alignment of data labels in my chart so that they are vertical. Is there any way of applying this format to all the data labels at once as everytime I alter the source data in the chart, the labels change back to horizontal alignment and I have to manually change the label format. -- 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 | Excel Discussion (Misc queries) | |||
Data labels on chart | Charts and Charting in Excel | |||
Excel 2002: How to realign data table ? | Excel Discussion (Misc queries) | |||
Pie Chart Data Labels | Charts and Charting in Excel | |||
Pie Chart Data Labels | Charts and Charting in Excel |