Charting multiple entries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

swoperet - 21 Sep 2007 23:08 GMT

New to Excel 2002 and its terminologies, I need to know, before tackling
excercises in the 'Dummies' workbook, if it's possible to record the
following information in a spreadsheet. I need to document utility usage for
the past 20 years for up to 10 utilities, recording cost on a per monthly
basis and be able to merge all 10 utilities usage into a single graph. From
reading the table of contents in Mr. Harvey's book, I'm not seeing a tutorial
covering the specific instance where more than one utility (for example) can
be charted for the row, column headers of date and cost respectively. Any
help would be appreciated.

Signature

Binder

Reply to this Message

MartinW - 22 Sep 2007 16:24 GMT

Hi Binder,

Setup your chart for the first utility, then right click on the blank area
at the top of the chart and select Source Data, then on the series
tab you will see the option to Add series. Set the reference for
your X and Y data for each new series (utility).

Excel will assign different colors and markers for each series,
these can be changed after you are done by right clicking on a data
point in the chart and selecting Format data series.

HTH
Martin

> New to Excel 2002 and its terminologies, I need to know, before tackling
> excercises in the 'Dummies' workbook, if it's possible to record the
[quoted text clipped - 9 lines]
> be charted for the row, column headers of date and cost respectively. Any
> help would be appreciated.

Reply to this Message

MartinW - 22 Sep 2007 16:37 GMT

I should also add that you can find out just about anything
you will ever need to know about charting at Jon Peltiers site.

http://peltiertech.com/Excel/Charts/index.html

As an added bonus Jon is a regular and prolific contributor
to these newsgroups but he spends the majority of his time
in the charting group, so you are better off posting chart
questions there.

HTH
Martin

> Hi Binder,
>
[quoted text clipped - 24 lines]
>> Any
>> help would be appreciated.

Reply to this Message

swoperet - 22 Sep 2007 19:24 GMT

Martin,

Thanks for the tip on my Excel impasse. Also, the lead on Mr. Peltier's
contributions to the chart site. If I have further complications, I won't
hesitate to query Jon or others at this community site. Thanks for the help!

Signature

Binder

> I should also add that you can find out just about anything
> you will ever need to know about charting at Jon Peltiers site.
[quoted text clipped - 37 lines]
> >> Any
> >> help would be appreciated.

Reply to this Message

Rate this thread: