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

R

Rav99

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One Column on 1st y-axis and 3 lines on 2nd y-axis 1
Making Data and Axis Labels Different 2
Labeling on independently stacked line chart 0
change chart primary horizontal axis label or name 1
Pivot Chart - X-axis labels when adding data 0
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
X Y (Scatter) Chart EXCEL 2007 1
Excel 2007: X-axis labeling 1

Top