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
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