Ploting data with a large range including negative numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am trying to plot a scatter chart with percentage growth as the y axis.
The range of growths runs from negative to plus several thousand. I would
like to use a log scale but clearly this will not cope with negatives. Any
ideas would be gratefully received!
Many thanks
Keith
 
You could separate the positive and negative data and plot the absolute
values of the negative vales in a different color
 
You must log in or register to reply here.

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

Is that a bug in Excel 2007 ? Wrong automatic range for negative v 1
Secondary Axis not crossing at zero 4
plot data on two axis at the same time, metric and english units 2
Negative or zero values cannot be plotted correctly on log charts 6
time scale-x with scattered data-y 1
Zero values in a log chart 1
reversing the axis on a chart 2
How to keep category and value axes the same 9

Back
Top