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: 40
Default Graph where source data has different dates

I'm trying to do a comparision line graph with two series of data. The are
both tracked by date with the same range (from April 2008 to April 2009).
However one series has data monthly and the other has data weekly. When I
try to combine on a graph the dates just don't line up.

Is it possible to have these line up correctly. I've tried formatting the
axis to days instead of months but it appears to only line up data points.
So for the data reported monthly, it is graphed across the first 12 days.

Hopefully that makes sense. If not, just let me know & I'll try to clarify.

Thanks!
 
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
Change Source Data in a Graph James D. Sheehan Excel Discussion (Misc queries) 1 August 24th 07 02:10 AM
showing source data from a graph [email protected] Excel Discussion (Misc queries) 0 September 14th 06 10:53 PM
Data Source for excel graph prakash Excel Discussion (Misc queries) 1 September 13th 06 09:38 AM
Graphs/Charts by country. Same Graph, different Source Data Dan_Green Charts and Charting in Excel 0 July 19th 05 01:37 PM
Excel graph source data RRRBBB Charts and Charting in Excel 4 June 9th 05 05:16 AM


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

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

About Us

"It's about Microsoft Excel"