Really big scale on scatter graph on Excel!!

Microsoft Office 2007 home and student
March 28, 2011 at 14:32:17
Specs: Windows Vista
Hi, basically my problem is with my values for the Y axis in a scatter graph.
My scale at the moment is too big as my values go from 957 tonnes to 46 million tonnes. If I use a scale only in millions, then my values under a million all show up at zero in the graph. But if I use a scale of 10,000s then my Y axis is enormous.

Any ideas how I can overcome this problem? And is it even possible to this in Excel?

Thanks


See More: Really big scale on scatter graph on Excel!!

Report •

#1
March 28, 2011 at 23:31:38
That's what log paper is for.

Report •
Related Solutions


Ask Question