View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Zb Kornecki Zb Kornecki is offline
external usenet poster
 
Posts: 23
Default Column/line graph settings

These solutions are always so simple when you know what they are. My
presentation will much better thanks to your help. I appreciate it. Zb

"Andy Pope" wrote:

Hi,

Ignore the built-in combination graphs and create your own.
Start by creating a column chart based on ALL data series.
Select the last series, right click and pick Chart Type. Select Line chart
you want.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Zb Kornecki" <zDOTkorneckiATcomcastDOTnet wrote in message
...
I am trying to creat a column /line graph w/ 6 series and want only the
last
one to be "on the line" . Excel keeps putting 3 series in columns and 3
on
lines. Is there any way to change this behavior? Thanks Zb