Excel chart question

How do I change a series from a bar to a line in a mixed bar-line chart?

Hi,

Select the series and then right click, on the popup menu select chart
type and then pick the required line chart.

Or select the series and then from the menu Chart > Chart Type, select
the required line type.

Cheers
Andy

yadernye wrote:
> How do I change a series from a bar to a line in a mixed bar-line chart?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Brilliant! Thanks, Andy.

Cheers,

Shawn

"Andy Pope" wrote:

> Hi,
>
> Select the series and then right click, on the popup menu select chart
> type and then pick the required line chart.
>
> Or select the series and then from the menu Chart > Chart Type, select
> the required line type.
>
> Cheers
> Andy
>
> yadernye wrote:
> > How do I change a series from a bar to a line in a mixed bar-line chart?
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>