Excel graph: turn stacked bar chart into part bullet chart
- by Mike
I've a simple data file that has one column of actuals and another of target against categories. I would like to turn the TARGET figure into a 'Bullet marker'. I've seen it done on other graphs but I'm struggling with the category column being overwritten with the xy axis values. Or if I get close to doing it then the xy markers are not central.
I've checked out Peltier but his examples are based on even more comlicated data than mine, so the steps required didn't seem to match up.
Help greatly appreciated.
Thanks
Mike.
Example Data:
Cat Actual target
A 10 15
B 10 12
C 20 17