scatter charting with two Y axes. Possible?

[schreib]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I charted two series of data using a LINE chart with two vertical axis. I notice in Excel 2004 there is no selection to be able to chart the same basic thing using a SCATTER plot. I NEED a scatter plot for two reasons: 1) I want to see the X axis as a constant increment(time line) rather than category and LINE plots force it to be ONLY categories. 2) I want to ADD more source data as it is generated and the two LINE chart selection allows only TWO basic sets of data. I can't add more in later without re-working my spreadsheet. 3) I don't want to re-working my spreadsheet. I want to be able to leave the arranged data "as is".

Is there a good solution? I simply would like to have a double vertical axis scatter chart and then add data by choosing additional "data sources". Thanks Brian

 

[Carl Witthoft]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I charted two series of data using a LINE chart with two vertical axis. I
notice in Excel 2004 there is no selection to be able to chart the same basic
thing using a SCATTER plot. I NEED a scatter plot for two reasons: 1) I want
to see the X axis as a constant increment(time line) rather than category and
LINE plots force it to be ONLY categories. 2) I want to ADD more source data
as it is generated and the two LINE chart selection allows only TWO basic
sets of data. I can't add more in later without re-working my spreadsheet. 3)
I don't want to re-working my spreadsheet. I want to be able to leave the
arranged data "as is".

Is there a good solution? I simply would like to have a double vertical axis
scatter chart and then add data by choosing additional "data sources". Thanks
Brian

Yes. Not difficult, just hidden.
One way: start by plotting two or more sets of data as Scatterplot.
Then click on one of the datasets (in the chart) and select
FormatSelectedSeries. Somewhere in there you can click "Secondary Y
axis" and Poof! it's on the chart.

HOWEVER: beware that choosing to display multiple sets of data with
different vertical scales is one of those "path to hell paved with good
intentions" things. Many articles have been written about how this can
lead to dangerously misleading graphs -- unless of course that's what
you want to do

 

[schreib]

Thanks a bunch Carl. I really appreciate your help.

I will try it while being wary. I think I understand your point about "path to hell paved with good intentions"!

Just wondering what the connection is with EM pinball and what the "EM" stands for?! Brian