Bar and Line plots on the same chart

's Computer Specifications

Is there a way to have some data plotted as bars and other data as lines on
the same chart?

Appreciate any suggestiuions.

Dave
WinXP SP3 Office (Excel)2003

's Computer Specifications

Hi,

Yes, you need to plot the line as an xy-scatter in order to get the line
to go vertically. with Y values being used to align the points with the
bars.

Cheers
Andy

On 12/05/2010 16:05, Dave wrote:
> Is there a way to have some data plotted as bars and other data as lines on
> the same chart?
>
> Appreciate any suggestiuions.
>
> Dave
> WinXP SP3 Office (Excel)2003
>
>

--

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

's Computer Specifications

Thank you Andy - it works :-)
Dave

"Andy Pope" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> Yes, you need to plot the line as an xy-scatter in order to get the line
> to go vertically. with Y values being used to align the points with the
> bars.
>
> Cheers
> Andy
>
> On 12/05/2010 16:05, Dave wrote:
>> Is there a way to have some data plotted as bars and other data as lines
>> on
>> the same chart?
>>
>> Appreciate any suggestiuions.
>>
>> Dave
>> WinXP SP3 Office (Excel)2003
>>
>>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
line chart plots false value and the real value on same date	Isabel	Microsoft Excel Charting	0	10th Feb 2010 01:18 PM
can i do multiple plots on 3d chart?	=?Utf-8?B?bXJwbGVj?=	Microsoft Excel Charting	1	7th Jun 2006 04:20 PM
Box-and-whisker chart (box plots)	=?Utf-8?B?SmFtZXM=?=	Microsoft Excel Charting	2	3rd Apr 2006 01:14 AM
two scatter plots with two trendlines on one chart	Leo Bueno	Microsoft Excel Charting	1	14th Nov 2005 12:47 AM
Excel gives me line plots - I want scatter plots	=?Utf-8?B?UGFuZ2xvc3M=?=	Microsoft Excel Charting	1	14th Oct 2005 02:15 PM