![]() |
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