PC Review


Reply
Thread Tools Rate Thread

Aligning line chart with column chart (4 categories)

 
 
Dream
Guest
Posts: n/a
 
      13th Jan 2010
Hi All,

I am trying to plot a line chart over a column chart (4 categories). The
columns on the primary y-axis, while the lines on the secondary y-axis. The
problem is that the line charts starting points are always at the middle of
the data series but not properly aligned with the columns. I want to shift
them and align them with the column charts. Here is the data.

2011 2011 2012 2012
Volume % of sector Volume % Sector
Company 1 150 7% 310 11%
Company 2 170 5% 320 12%
Company 3 160 4% 330 13%

If you plot them in columns, you will see 4 groups on the X-axis: Volume
2020, % Sector 2020, Volume 2030, % Sector.

But I want it to be showing only 2 groups (representing years)on the X-axis:
2020 and 2030, and in each year, there are 3 columns (for volume on the
primary y-axis), and over them there is the line chart (on the secondary
y-axis):

one blue line starting from Company 1 column at 7% on the secondary y-axis
in 2011, extending to Company 1 blue column in 2012 at 11%. Another red line
for company 2 following the same idea. And a green line for the last green
column for company 3.

I look forward to your feedback.

Thanks in advance
 
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
How can I combine a stacked column chart and line chart? Huib Microsoft Excel Charting 1 22nd Oct 2009 10:41 AM
Combination chart - aligning column categories with time-scale x-a =?Utf-8?B?UmFi?= Microsoft Excel Charting 0 24th Oct 2007 04:46 PM
Chart Error when using Chart Line - Column on 2 Axes in vba code =?Utf-8?B?Sm9obg==?= Microsoft Excel Programming 2 3rd Aug 2007 01:42 PM
How can I add a line chart in a stacked column chart style? =?Utf-8?B?R3VpbGhlcm1lIExvcmV0dGk=?= Microsoft Excel Misc 0 3rd Aug 2006 01:46 AM
Comparing Line Chart and Column Chart? Nev. Microsoft Excel Charting 1 3rd Jul 2004 06:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:45 AM.