I have a line chart that has values ranging from 10 to 1,000,000. I need to use the log scaling option to display my series properly. Everytime I try to select the logarithmic scale and close the chart editor, the scale returns to linear.
I have tried everything I could think of. I've tried manual scaling. I even used 8.5 to select the scale and then saved it in 7.0 format. This creates curved lines on my chart and I need straight lines connecting one point to another in a series.
Any suggestions? I'd prefer to stay with version 7 for now if I can get this to work.
Thanks in advance for your reply.
I have tried everything I could think of. I've tried manual scaling. I even used 8.5 to select the scale and then saved it in 7.0 format. This creates curved lines on my chart and I need straight lines connecting one point to another in a series.
Any suggestions? I'd prefer to stay with version 7 for now if I can get this to work.
Thanks in advance for your reply.