How do I change column into lines on a Line-Column chart?

#1 03-17-2005, 10:06 AM

I want to create a chart with three columns and one line using two axis. Any
help would be useful.

Thanks

#2 03-17-2005, 11:06 AM

Hi Ken,

Create a column chart based on all your data. Select the series that you
want as line and right click it. Choose Chart Type and change it to
Line. Now double click the new line so you can change the Axis value to
secondary.

Cheers
Andy

Ken wrote:
> I want to create a chart with three columns and one line using two axis. Any
> help would be useful.
>
> Thanks

--

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)