Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm trying to create a thematic map in Excel | Excel Worksheet Functions | |||
How do I create chart that show percentages for 1 and 0's? | Excel Worksheet Functions | |||
How do I create a chart that will show 4 weeks of current info? | Charts and Charting in Excel | |||
data classes | Excel Discussion (Misc queries) | |||
need template for college course schedule that will chart classes | Charts and Charting in Excel |