On Tue, 3 Jun 2008, in microsoft.public.excel.charting,
Min said:
I wanted to use bar charts so easiler to analyse the differences between each
of the columns. Think I tried line graphs but I still can't get it in order
for all the categories (columns) without changing the other graphs. Would it
be possible or is it better to use access? Or can u recommend another
software?

I understand later versions of Access have graphs, so that might work.
But you haven't really told us enough about your data to help you solve
your problem. Often, the hardest part about helping people in this
newsgroup to chart their Excel ranges is that they treat the details of
those ranges like a poker hand, and the details are key to answering the
question.

Reading between the lines, I don't see why it shouldn't be just as
feasible to use a Pivot table as to move the data over to Access.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.