Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Get data labels off of my data series!
I have a clustered column chart with 2 data series. Data labels are formulas
which pull values from another sheet (used to show the delta between the 2 data series). For some reason, they like to sit right on top of one of the data series, and each time the chart is updated I have to move the labels up. This is extremely annoying and I'd like the labels to get the heck out of the way without my manual intervention. I tried changing the label position under Label Options, and I also tried changing the vertical alignment under Alignment, Text Layout - both to no avail. Help! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Get data labels off of my data series!
You could add a line chart series to the chart, using Y values that put the
points where you think the labels should be positioned. Format the line series to have no markers or lines, and affix the labels to this series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mike" wrote in message ... I have a clustered column chart with 2 data series. Data labels are formulas which pull values from another sheet (used to show the delta between the 2 data series). For some reason, they like to sit right on top of one of the data series, and each time the chart is updated I have to move the labels up. This is extremely annoying and I'd like the labels to get the heck out of the way without my manual intervention. I tried changing the label position under Label Options, and I also tried changing the vertical alignment under Alignment, Text Layout - both to no avail. Help! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Get data labels off of my data series!
WOW. That's why they call you an MVP. :-)
"Jon Peltier" wrote: You could add a line chart series to the chart, using Y values that put the points where you think the labels should be positioned. Format the line series to have no markers or lines, and affix the labels to this series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mike" wrote in message ... I have a clustered column chart with 2 data series. Data labels are formulas which pull values from another sheet (used to show the delta between the 2 data series). For some reason, they like to sit right on top of one of the data series, and each time the chart is updated I have to move the labels up. This is extremely annoying and I'd like the labels to get the heck out of the way without my manual intervention. I tried changing the label position under Label Options, and I also tried changing the vertical alignment under Alignment, Text Layout - both to no avail. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Series Labels in Area Chart | Charts and Charting in Excel | |||
Formatting ALL data labels for ALL data series at once | Charts and Charting in Excel | |||
data series and axis labels | Charts and Charting in Excel | |||
How to add data labels from a series not displayed on a chart | Charts and Charting in Excel | |||
XL Charts: Let my mouse drag all data labels for a whole series. | Charts and Charting in Excel |