Wide data range
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? |
Wide data range
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. "Tushar Mehta" wrote: In article , says... 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 |
All times are GMT +1. The time now is 06:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com