LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 27
Default Combine Bar with Single Line Chart

Hello,
Please can someone help me with this question. I am trying to create
a bar chart with a single line chart.

The bars will display the totals for various years i.e.

2004 104
2005 107
2006 108
2007 110
2008 101

The line chart will show how 2008 is performing on a weekly basis i.e.

01/01/2008 = 100
07/01/2008 = 101
14/01/2008 = 102

The bar chart for 2008 will reflect this also, updating each time a
new week is added.

The Y Axis I will assume display a total i.e. 99-111 for example.

The X Axis needs to show the dates plotted for the line chart
01/01/2008 - 31/12/2008 (weekly) but how can I display the bar charts
on this axis?

If anyone can help I would be extremely grateful.

Brett
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to combine stock and line to one chart Valley[_2_] Excel Discussion (Misc queries) 1 August 30th 07 01:03 PM
Combine non-matching dates in single chart daan1903 Charts and Charting in Excel 2 March 1st 07 01:00 PM
how to combine a vertical line chart into a bar chart? e4ella Charts and Charting in Excel 3 August 11th 06 03:18 PM
Combine candle and line in a single chart Bert Charts and Charting in Excel 1 January 20th 05 01:08 PM
Combine candle and line in a single chart Bert Charts and Charting in Excel 4 January 19th 05 07:23 AM


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"