ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Putting the value from second axis above the "bar"? (https://www.excelbanter.com/charts-charting-excel/190952-putting-value-second-axis-above-bar.html)

Mikael Lindqvist

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

Jon Peltier

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





All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com