Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
share|improve this question
    
I'm not sure I understand what you mean by "bullet marker". Can you draw a picture of what you'd like on your chart? –  Martha Nov 5 '10 at 18:40
add comment

1 Answer

Did you mean something like this?

Bar chart with "bullets" indicating target values

If so, here's how:

Create a bar chart with both Actual and Target being two seperate series.

Then select the Target series and set the Chart Type (of just that series!) to X-Y Scatter.

Then format the Target series to have no line and adjust the visual style, colour and size of the point marker as desired.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.