Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Putting the value from second axis above the "bar"?
Hi,
I like using combination charts with second value axis, where one useful combination is first axe display bar and second a line. However, would it be possible to have the second axis display its proper value (digit) above the bar? In my case the bar would display a sum-value (customer turnover) and second value displays total number of customers. Kindly, Mikael Sweden |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Putting the value from second axis above the "bar"?
You could add a label to the bar, locate it above the bar, and use the other
label. You can manually edit a label, or use one of these free utilities to add a custom label: Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm John Walkenbach's Chart Tools, http://www.j-walk.com/ss/excel/files/charttools.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mikael Lindqvist" wrote in message ... Hi, I like using combination charts with second value axis, where one useful combination is first axe display bar and second a line. However, would it be possible to have the second axis display its proper value (digit) above the bar? In my case the bar would display a sum-value (customer turnover) and second value displays total number of customers. Kindly, Mikael Sweden |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Putting "My Music" file in Excel 2003 | Excel Discussion (Misc queries) | |||
how do I type "itis" without Excel putting a space "it is"? | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |