| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data labels in middle of the chart
Is there a way to move data labels. I have negative and positive values on my
chart and it caused the axis to move up, but so did the labels. and now the lables are in the middle accross the data points. looks busy. is there anyway to have the labels display on the bottom of the bar chart even though the axis is not at the bottom anymore? -- Hile |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data labels in middle of the chart
Double click on the axis, and on the Patterns tab, for Tick Mark Labels,
choose Low. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "hile trotman" wrote in message ... Is there a way to move data labels. I have negative and positive values on my chart and it caused the axis to move up, but so did the labels. and now the lables are in the middle accross the data points. looks busy. is there anyway to have the labels display on the bottom of the bar chart even though the axis is not at the bottom anymore? -- Hile |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data labels in middle of the chart
Thanks so much. I knew I could do it I just couldn't remember where on earth
that was. You guys rock! -- Hile "Jon Peltier" wrote: Double click on the axis, and on the Patterns tab, for Tick Mark Labels, choose Low. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "hile trotman" wrote in message ... Is there a way to move data labels. I have negative and positive values on my chart and it caused the axis to move up, but so did the labels. and now the lables are in the middle accross the data points. looks busy. is there anyway to have the labels display on the bottom of the bar chart even though the axis is not at the bottom anymore? -- Hile |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Labels on Filtered Data | Charts and Charting in Excel | |||
| How do I print comments on a chart? | Charts and Charting in Excel | |||
| Can I use data from different worksheets to create a chart | Charts and Charting in Excel | |||
| Pie chart data labels and lines disappear | Charts and Charting in Excel | |||
| How do I get my data labels on a pivot chart to retain their form. | Charts and Charting in Excel | |||
Hybrid Mode
