Charts show the data they're given. You would have to either manually move
data around in the sheet, or write formulas (lookups, etc) to do this for
you.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mahurshi Akilla" wrote in message
...
Is there a way to get a histogram chart in excel with two series, each
with different X values?

for e.g.

Series1
a 10
b 20
c 30
d 40


Series 2
a 100
d 400
b 200


(assume 1st column represents X values and 2nd column represents Y
values)

note that though some X values are the same in both series, there are
some inconsistencies.

is there a way to get a histogram chart in excel, which would
automatically put together the things that belong to the same X ?

Thanks