charting multiple identical x values overlapping

  • Thread starter Thread starter evrk
  • Start date Start date
E

evrk

A B
red 1
blue 2
orange 3
red 4

If I graph the above set of data in a bar chart, with column A being the x-axis and column B being the Y axis, I'm having issues finding a way to format how excel handles multiple instances of the same x value ('red' in this case).

Currently, it displays both '1' and '4' merged together in the same bar. When you look at it, the bar just looks messed up rather than like two distinct entries.

Ideally, they would be displayed as two separate side-by-side bars, or, even better, with a combined value of 5.

Is there any way to accomplish this?

----
Excel 2007
Win 7

Submitted via EggHeadCafe
SQL Operations on a Text File with ADO.NET
http://www.eggheadcafe.com/tutorial...ql-operations-on-a-text-file-with-adonet.aspx
 
I had tried the same thing u did i get two different bars for red one bar in starting n other one at the end please do try it again hope u would get separate bar or shall i send the excel file on which i had done please to provide ur email id so I can send u the file
 
Back
Top