You could edit the series formula (which is actually how I prefer to do
this). Select the series and look in the formula bar. Change this:
=SERIES(????,Sheet1!$A$2:$A$12,Sheet1!$D$2:$D$12,1 )
to this:
=SERIES(????,(Sheet1!$A$2:$A$12,Sheet1!$A$2:$A$12, Sheet1!$A$2:$A$12),(Sheet1!$D$2:$D$12,Sheet1!$E$2: $E$12,Sheet1!$F$2:$F$12),1)
where ???? is either blank, a text string in quotes, or a range address,
used for the series name.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Novice" wrote in message
...
Thanks. Is there a way to maneuver around the 'series' box without
changing
the formula unintentionally? Long formulas are hard to edit
"Jon Peltier" wrote:
The easy way:
Duplicate A2:A12 in A13:A23 and A24:A34. Copy E2:E12 to D13:D23 and
F2:F12
to D24:D34 and make your chart from columns A and D.
Hard way:
Make the chart using A2:A12 and D2:D12. Go to Chart menu Source Data
Series. Select the series, change X values from
=Sheet1!$A$2:$A$12
to
=Sheet1!$A$2:$A$12,Sheet1!$A$2:$A$12,Sheet1!$A$2:$ A$12
and change Y values from
=Sheet1!$D$2:$D$12
to
=Sheet1!$D$2:$D$12,Sheet1!$E$2:$E$12,Sheet1!$F$2:$ F$12
and click OK.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Novice" wrote in message
...
Hi, I would like to create a single chart using multiple columns as
one
series
error message states that title, values, sizes must be single cell, row
or
column...
x axis A2:A12 y axis D2:F12 (legend name)
Thanking you in advance.