2 line one bar graph

's Computer Specifications

I need to create graph which has min and max target and actual data each month
I would like to show each target as a line and actual as bar I can get 2 bar and one line but not other way roun
thank
tina

's Computer Specifications

Hi
have a look at the following sites for creating lines in your chart:
http://andypope.info/charts/averageline.htm
http://www.tushar-mehta.com/excel/ch...nes/index.html
http://peltiertech.com/Excel/Charts/...s.html#AddLine

--
Regards
Frank Kabel
Frankfurt, Germany

"tina" <(E-Mail Removed)> schrieb im Newsbeitrag
news:8BF1B9D7-6207-48BD-BEAB-(E-Mail Removed)...
> I need to create graph which has min and max target and actual data
each month
> I would like to show each target as a line and actual as bar I can
get 2 bar and one line but not other way round
> thanks
> tina

's Computer Specifications

Tina -

An easier way than Frank suggested is to make the chart with three line
series, then select the one you want to change, and choose Chart Type
from the Chart menu. Pick out the column style you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

tina wrote:

> I need to create graph which has min and max target and actual data
> each month I would like to show each target as a line and actual as
> bar I can get 2 bar and one line but not other way round thanks tina

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining a 2-D column graph and a 2-D line graph on the same char	Filippo	Microsoft Excel Charting	3	23rd Feb 2010 12:34 AM
Changing Line Graph Colors in Microsoft Graph	Neil Ginsberg	Microsoft Access	0	18th Nov 2008 06:45 PM
Changing Line Graph Colors in Microsoft Graph	Neil Ginsberg	Microsoft Access Reports	0	18th Nov 2008 06:45 PM
How do I graph data daily as a line graph across a calendar format	=?Utf-8?B?R2xhbmk=?=	Microsoft Excel Charting	3	23rd Nov 2007 09:05 AM
Cluster stacked graph AND line combo graph?	robotman@gmail.com	Microsoft Excel Charting	6	14th Oct 2006 12:33 AM