Excel chart

[ashtonp2]

Hi

I am creating a line and column chart. Some of the data it has formatted as columns and I want it to be displayed as a lines. How can I change some of the columns to line and leave the others as columns.

I am sure this is really easy, but I can not see how to do it

Paul
PS I am using Excel 97

 

[xlbo]

Select the data series (left Click) then Right click and select Chart Type. Make sure the tick box is ticked for "Selected Series" and then choose your chart type for the series

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244