PC Review


Reply
Thread Tools Rate Thread

Changing data types on Line/bar with two axes

 
 
=?Utf-8?B?cm9qbzY5NjQ=?=
Guest
Posts: n/a
 
      24th May 2006
I have four data series, it shows 2 as bars and 2 as lines. I want to show
just one series as bars and 3 as lines. How do I change data series 2 from
bars to lines?
 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      24th May 2006
Hi,

Right click the series and pick Chart Type. Select the required chart type.

It is normally quicker to start with a line chart for all 4 series and
then select one of the series to change to a bar/column chart.

Cheers
Andy

rojo6964 wrote:
> I have four data series, it shows 2 as bars and 2 as lines. I want to show
> just one series as bars and 3 as lines. How do I change data series 2 from
> bars to lines?


--

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

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seondary axes line-chart not showing as per data =?Utf-8?B?QXNpZg==?= Microsoft Excel Charting 3 13th Nov 2007 04:41 PM
Adjusting the y axes on 2-axes line graphs =?Utf-8?B?YXF1YQ==?= Microsoft Excel Charting 2 3rd Mar 2007 04:28 PM
Line column on 2 axes - stacked columns data not stacking BillGilm@gmail.com Microsoft Excel Charting 4 15th Feb 2007 09:44 AM
Changing Line to Bar when you have 2 axes =?Utf-8?B?Q2FyYQ==?= Microsoft Powerpoint 1 10th Mar 2006 09:39 PM
stacked column on primary axes, line on secondary axes - possible? Michelle Microsoft Powerpoint 0 9th Jul 2003 04:18 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:22 PM.