[sonicscooter]

Hi, i have a line--column chart with 8 data sources on it, 4 are columns and
4 are lines with markers on, the markers i have removed to make them just a
plain line...4 of the data sources are positive numbers, 4 are negative
numbers....simple. If i was to add another data source to this chart by
pressing add in the Source Data box, then using the values box etc, i end up
with a another column on the chart, how can i change this to a line or from a
line to a column, i don't know if i have control over what i get on the
chart.

Thanks for any advice,

Shane.

[Andy Pope]

Hi,

You can select the new series and change it's chart type.
Try right clicking the selected series and Chart Type.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sonicscooter" wrote in message
...
Hi, i have a line--column chart with 8 data sources on it, 4 are columns
and
4 are lines with markers on, the markers i have removed to make them just
a
plain line...4 of the data sources are positive numbers, 4 are negative
numbers....simple. If i was to add another data source to this chart by
pressing add in the Source Data box, then using the values box etc, i end
up
with a another column on the chart, how can i change this to a line or
from a
line to a column, i don't know if i have control over what i get on the
chart.

Thanks for any advice,

Shane.

[sonicscooter]

Thanks Andy, i tried it and it works fine....Cheers.

"Andy Pope" wrote:

Hi,

You can select the new series and change it's chart type.
Try right clicking the selected series and Chart Type.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sonicscooter" wrote in message
...
Hi, i have a line--column chart with 8 data sources on it, 4 are columns
and
4 are lines with markers on, the markers i have removed to make them just
a
plain line...4 of the data sources are positive numbers, 4 are negative
numbers....simple. If i was to add another data source to this chart by
pressing add in the Source Data box, then using the values box etc, i end
up
with a another column on the chart, how can i change this to a line or
from a
line to a column, i don't know if i have control over what i get on the
chart.

Thanks for any advice,

Shane.