I need to change the scale intermittently on a graph. Here's what my data points look like:
Jan 2
Feb 10
Mar 50
Apr 600
May 5,000
Jun 75,000
Jul 1,000,000
You get the idea. The problem is that a regular graph mostly picks up the last two datapoints because of the enormous size difference. You cant see the change at the lower levels. Is there a way to manually set each intercept point so that there is the same amount of space in between 2, 10, 50, 600, etc? I basically want the line to be more or less straight and about 45 degrees. Anyone have any ideas?
Thanks a lot for the help
Bookmarks