ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Y2 Axis Labels on Y1 Data Point (https://www.excelbanter.com/charts-charting-excel/145661-y2-axis-labels-y1-data-point.html)

Brad K.

Y2 Axis Labels on Y1 Data Point
 
I am trying to create a chart that the primary Y axis shows the percent of
positive responses for each period in time. Rather than have the actual
percent show up as the Data Label, I would like to have N (total number of
responses) show as the Data Label for each - or some other visually
meaningful way to make this happen.
Thanks,
Brad K

Jon Peltier

Y2 Axis Labels on Y1 Data Point
 
Use one of these free and useful utilities to apply labels from other cells:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brad K." wrote in message
...
I am trying to create a chart that the primary Y axis shows the percent of
positive responses for each period in time. Rather than have the actual
percent show up as the Data Label, I would like to have N (total number of
responses) show as the Data Label for each - or some other visually
meaningful way to make this happen.
Thanks,
Brad K





All times are GMT +1. The time now is 05:31 PM.

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