I have the data set shown below and I have use it to produce the following bar chart - https://www.evernote.com/l/AdyXDHxZg29OR6p8DIRRtveKyxIVErog394 - that I would like to colour code using this colour scheme (based on the category) - https://www.evernote.com/l/AdzKudLCwm5FJKIxFLz88LT7YwGThI7xpqo.
Can anyone explain how I do this?
<!--StartFragment--> <colgroup><col width="65" span="3" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
Can anyone explain how I do this?
Street Name | Total Count | Category |
Second | 2022 | Numbers |
First | 1914 | Numbers |
Third | 1652 | Numbers |
Main | 1607 | Other |
Fourth | 1492 | Numbers |
Maple | 1138 | Nature |
Fifth | 1127 | Numbers |
Park | 1104 | Nature |
Church | 993 | Other |
Sixth | 967 | Numbers |
Pine | 904 | Nature |
Birch | 846 | Nature |
Railway | 801 | Other |
Cedar | 783 | Nature |
Seventh | 780 | Numbers |
River | 670 | Nature |
Spruce | 665 | Nature |
Mill | 640 | Other |
Poplar | 619 | Nature |
Willow | 616 | Nature |
Eighth | 591 | Numbers |
Elm | 530 | Nature |
Tenth | 527 | Numbers |
Ninth | 521 | Numbers |
Victoria | 501 | Royalty |
Oak | 498 | Nature |
King | 479 | Royalty |
Sunset | 475 | Nature |
Lake | 460 | Nature |
Aspen | 428 | Nature |
Centre | 395 | Other |
Mountain | 395 | Nature |
Lakeview | 379 | Nature |
Queen | 371 | Royalty |
Eleventh | 341 | Numbers |
James | 334 | People |
Smith | 333 | People |
George | 327 | People |
Martin | 311 | People |
Albert | 308 | People |
Campbell | 296 | People |
William | 295 | People |
North | 293 | Other |
Woodland | 293 | Nature |
Wilson | 288 | People |
Elizabeth | 283 | Royalty |
Riverside | 282 | Nature |
<!--StartFragment--> <colgroup><col width="65" span="3" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>