Wide data range

[chasida]

I am charting rainfall for 4 cities over 12 months. 3 of the cities have
ranges between 0-6mm of rain per month but the 4th city has ranges of 0-55mm
of rain. when i chart this either as a bar or line graph because of the
disparate range it is very hard to see the data. any suggestions?

 

[Tushar Mehta]

I am charting rainfall for 4 cities over 12 months. 3 of the cities have
ranges between 0-6mm of rain per month but the 4th city has ranges of 0-55mm
of rain. when i chart this either as a bar or line graph because of the
disparate range it is very hard to see the data. any suggestions?

The easiest way out might be to put one range of data on the primary axis
and the other on the secondary axis. To do so, double-click the plotted
series that you want on the secondary axis, then select the Axis tab
and...the rest will be self-evident. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[chasida]

I tried what you said and it is still unclear. The data of the 4th city then
covers the data of the other cities and it is hard to understand that the
other cities belong to the x axis values.