Line-- Column charts

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.

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.

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.