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.

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.

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.

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.

Thanks again. That works great on charts that need to edited. The formula
bar doesn't show a long series formula for new charts. I've looked to see if
I have that turned off but can't find where that would be.

"Jon Peltier" wrote:

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.

I don't understand this:

The formula bar doesn't show a long series formula for new charts.

If you select a series, you should get a SERIES formula in the formula bar.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Novice" wrote in message
...
Thanks again. That works great on charts that need to edited. The
formula
bar doesn't show a long series formula for new charts. I've looked to see
if
I have that turned off but can't find where that would be.

"Jon Peltier" wrote:

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.