create a thematic chart, to show different classes of data
I need to show the same basic data (in my case, journey times), but colour
coded or with labels to show different categories (in my eg, to show which journeys can be extended to the City & which require a change of bus). Childishly easy to conceptualise & surely not too difficult to do, but how? |
create a thematic chart, to show different classes of data
The way to do it is to create a series to represent each category.
For example, supposing the values to be charted were Name Amt a 24 b 29 c 10 d 45 e 44 f 99 g 66 h 91 i 25 j 60 and you want values <=20 to be red, 21-50, blue and 50 green in extra columns headed say Amt Red, Amt Green, Amt Blue, add formulae of =IF(B2<=20,B2,NA()) =IF(AND(B220,B2<=50),B2,NA()) =IF(B250,B2,NA()) then build your chart with the source data coming fform columns A, C, D & E. Then just format each series to your desired colour. -- __________________________________ HTH Bob "Bus user" <Bus wrote in message ... I need to show the same basic data (in my case, journey times), but colour coded or with labels to show different categories (in my eg, to show which journeys can be extended to the City & which require a change of bus). Childishly easy to conceptualise & surely not too difficult to do, but how? |
All times are GMT +1. The time now is 04:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com