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:
I'd want 1 and 2 to be labelled "Apples" and "Bananas" respectively.
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:
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.