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.
Apples   1
Apples   5
Apples   2
Bananas  1
Bananas  4
Bananas  6

I want two bars on the X axis (Apples, Bananas), but with crosses marking the points on the Y axis.

Here's a mockup:

enter image description here

I'd want 1 and 2 to be labelled "Apples" and "Bananas" respectively.

share|improve this question
    
isn't there a charts wizard that does this for you? –  SUPER MARIO BROTHERS Mar 13 '12 at 11:53
    
I can't find one. Do you know what it's called? –  Chris Mar 13 '12 at 12:38

1 Answer 1

To label 1 & 2, you can easily add two dummy series, one for each label. "Apple" series will be (1,0) and "Banana" series will be (2,0). Then, format the data points with no shape/fill/line and add a data label for each series name (located below the data point). Finally, modify the X axis formating to eliminate the default labels (and ticks, if you're inclined). You may have to tweak the plot area inside the chart to allow for enough room for the data labels. You'll end up with something like this: Scatter Labels

You also mentioned two bars on the X axis, with crosses on the Y axis. Did you mean something like a column chart? If you elaborate, there's probably an easy way to fix that as well.

share|improve this answer

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.