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. |
Line-- Column charts
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. |
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. |
All times are GMT +1. The time now is 09:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com