ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Charting question (https://www.excelbanter.com/excel-discussion-misc-queries/140606-charting-question.html)

Dabears70

Charting question
 
Is it possible to have two alternative scales on the same chart? If so How do
you set up the scale?

Thanks in advance for your help.
--
Nick

FloMM2

Charting question
 
DaBears70,
Excel's help on this subject is close, not ideal.
If put numbers in cells D1:D6,E1:E6,F1:F6, and G1:G6.
Selected scatter plot, named the series what i wanted to, selected G1:G6 as
my x-axis, for each series (D1:D6,E1:E6,F1:F6) finished the chart as an
insert.
Selected the third series(F1:F6),right click,format data series, Axis
tab,select "Secondary axis".
HTH
:-)

"Dabears70" wrote:

Is it possible to have two alternative scales on the same chart? If so How do
you set up the scale?

Thanks in advance for your help.
--
Nick



All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com