| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to colntrol location of category X axis labels on a bar chart?
How to colntrol location of category X axis labels on a bar chart?
usually data have only positive values, category X axis labels are in the left side of vertical axis (see labelsOK.jpg). When values are all negative, labels are crossing bars (see labels03.jpg). Basically labels are always to the left from vertical axis (see labels01.jpg and labels02.jpg) which is not always visually appealing. Is there a way to have labels for case when data are all negative, located to the right from the axis and axis itself indented from chart border, so it will be a mirror image of labelsOK.jpg (see labelsOKmirror.jpg, but of course text and digits should not be mirrored!). I do not see how to upload images, would happy to email them to whoever will be kind enough to ask ) for now I put them on a website http://spbdev.sprigley.com/labels01.jpg http://spbdev.sprigley.com/labels02.jpg http://spbdev.sprigley.com/labels03.jpg http://spbdev.sprigley.com/labelsOK.jpg http://spbdev.sprigley.com/labelsOKmirror.jpg Thank you! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to colntrol location of category X axis labels on a bar chart?
Hi,
The same approach is valid for bar charts http://www.andypope.info/tips/tip002.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Naum" wrote in message ... How to colntrol location of category X axis labels on a bar chart? usually data have only positive values, category X axis labels are in the left side of vertical axis (see labelsOK.jpg). When values are all negative, labels are crossing bars (see labels03.jpg). Basically labels are always to the left from vertical axis (see labels01.jpg and labels02.jpg) which is not always visually appealing. Is there a way to have labels for case when data are all negative, located to the right from the axis and axis itself indented from chart border, so it will be a mirror image of labelsOK.jpg (see labelsOKmirror.jpg, but of course text and digits should not be mirrored!). I do not see how to upload images, would happy to email them to whoever will be kind enough to ask ) for now I put them on a website http://spbdev.sprigley.com/labels01.jpg http://spbdev.sprigley.com/labels02.jpg http://spbdev.sprigley.com/labels03.jpg http://spbdev.sprigley.com/labelsOK.jpg http://spbdev.sprigley.com/labelsOKmirror.jpg Thank you! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to colntrol location of category X axis labels on a bar chart?
Not sure I fully understand, but couldn't you have a helper column and just
take the absolute value of your real values and chart them? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Naum" wrote in message ... How to colntrol location of category X axis labels on a bar chart? usually data have only positive values, category X axis labels are in the left side of vertical axis (see labelsOK.jpg). When values are all negative, labels are crossing bars (see labels03.jpg). Basically labels are always to the left from vertical axis (see labels01.jpg and labels02.jpg) which is not always visually appealing. Is there a way to have labels for case when data are all negative, located to the right from the axis and axis itself indented from chart border, so it will be a mirror image of labelsOK.jpg (see labelsOKmirror.jpg, but of course text and digits should not be mirrored!). I do not see how to upload images, would happy to email them to whoever will be kind enough to ask ) for now I put them on a website http://spbdev.sprigley.com/labels01.jpg http://spbdev.sprigley.com/labels02.jpg http://spbdev.sprigley.com/labels03.jpg http://spbdev.sprigley.com/labelsOK.jpg http://spbdev.sprigley.com/labelsOKmirror.jpg Thank you! |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to colntrol location of category X axis labels on a bar ch
no, I have 33 bar charts, they reflect rows on a data worksheet where data is
pasted - different every time, it is not going to fly with my users to build bar charts manually... Andy's solution seems to be working great (choose "Low" for "Tick mark labels" for Value axis - even if I do not understand it :-) "Bob Phillips" wrote: Not sure I fully understand, but couldn't you have a helper column and just take the absolute value of your real values and chart them? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Naum" wrote in message ... How to colntrol location of category X axis labels on a bar chart? usually data have only positive values, category X axis labels are in the left side of vertical axis (see labelsOK.jpg). When values are all negative, labels are crossing bars (see labels03.jpg). Basically labels are always to the left from vertical axis (see labels01.jpg and labels02.jpg) which is not always visually appealing. Is there a way to have labels for case when data are all negative, located to the right from the axis and axis itself indented from chart border, so it will be a mirror image of labelsOK.jpg (see labelsOKmirror.jpg, but of course text and digits should not be mirrored!). I do not see how to upload images, would happy to email them to whoever will be kind enough to ask ) for now I put them on a website http://spbdev.sprigley.com/labels01.jpg http://spbdev.sprigley.com/labels02.jpg http://spbdev.sprigley.com/labels03.jpg http://spbdev.sprigley.com/labelsOK.jpg http://spbdev.sprigley.com/labelsOKmirror.jpg Thank you! |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to colntrol location of category X axis labels on a bar ch
Andy, you did it again!! "Low" works good enough.
Thanks! "Andy Pope" wrote: Hi, The same approach is valid for bar charts http://www.andypope.info/tips/tip002.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Naum" wrote in message ... How to colntrol location of category X axis labels on a bar chart? usually data have only positive values, category X axis labels are in the left side of vertical axis (see labelsOK.jpg). When values are all negative, labels are crossing bars (see labels03.jpg). Basically labels are always to the left from vertical axis (see labels01.jpg and labels02.jpg) which is not always visually appealing. Is there a way to have labels for case when data are all negative, located to the right from the axis and axis itself indented from chart border, so it will be a mirror image of labelsOK.jpg (see labelsOKmirror.jpg, but of course text and digits should not be mirrored!). I do not see how to upload images, would happy to email them to whoever will be kind enough to ask ) for now I put them on a website http://spbdev.sprigley.com/labels01.jpg http://spbdev.sprigley.com/labels02.jpg http://spbdev.sprigley.com/labels03.jpg http://spbdev.sprigley.com/labelsOK.jpg http://spbdev.sprigley.com/labelsOKmirror.jpg Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Category Labels(X) axis on a chart: | Excel Worksheet Functions | |||
| In a bar chart, how do I change the x-axis "category" labels? | Excel Discussion (Misc queries) | |||
| Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
| Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
| Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Linear Mode
