ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   PivotChart - fix the 2nd Y-axis and show data labeling (https://www.excelbanter.com/charts-charting-excel/43968-pivotchart-fix-2nd-y-axis-show-data-labeling.html)

Rav99

PivotChart - fix the 2nd Y-axis and show data labeling
 
Hi all,

Deborah has helped me to fix the chart type (line-column 2 axes) after I
select different options. But I still encounter problems with:
1) Need to default the value of 2nd Y-axis from 0% to 100% with 10% as the
major unit. Right now, everytime I change the options, the percentage will
have autoscaling based on the logarithum calculation. How do I manually fix
the value range?
2) I want to show the data labels of the columns, but everytime when I
change the options, the data label disappears later on.

Can someone help???? Please...


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

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