dinsdag 17 juni 2014

Excel: Bar Chart With Wingdings and Symbols

On the occasion of a request from +Shane Devenshire I created this Excel chart:


My data:

Patients Time Since Treatment Response Time to Response → Ongoing response Y
10 17 23 11
9 19 7 13 4
8 38 25 15 4
7 48 0 36
6 52 12 27 4
5 59 10 20 4
4 60 23 37
3 89 5 25 4
2 90 16 69 4
1 98 25 24

The arrow is created using a label based op the column Ongoing Response, using the font Wingdings. The black circle is created using a label based on the Y column

What the orginal version looked like:


You can download the file ExcelShane.xlsx through

https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing
Een reactie plaatsen