Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Wide data range
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Match and Sort two range of data? | New Users to Excel | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |