Quote:
Originally Posted by texascpa
I followed the instructions provided. When I changed the values on the vertical axis from a percentage to a number, the vertical axis showed the correct information; however the information that I was plotting disappeared. The information came back when I changed the vertical axis back to percentage.
Question: How do I get the information plotted to show when I change the vertical axis to report a number?
|
Are you working on the same sample data? Add another column for the percentage format, say Rate (%). click your chart, add Rate (%) under the legend series, edit horizontal axis labels, select $D$2:$d:12. That is for the percentage, if you want the number format, edit the horizontal axis, select $c$2:$c$12. I hope this is what you need to know.