Posted to microsoft.public.excel.charting
|
|
Line-- Column charts
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.
|