Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-07-2014, 11:32 PM
expert4knowledge expert4knowledge is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Apr 2012
Posts: 59
expert4knowledge is on a distinguished road
Default Problem with have a chart with different data ranges

Hello everyone, I have a chart in excel that I have some financial data for some companies, some of data, for example cash flows are from July 2014 to June 2015 and each month has one data point, also there is another series that is related to a 3 months period, the data for that period is daily for the first 10 days of September and from that time to end of November they are weekly, how can I depict the second series in a chart that is ranged from July to June and then have a second series that starts from September(or August) and finishes in the November? Attached is an illustration of what I need.
Attached Images
File Type: jpg image001.jpg (37.2 KB, 9 views)
Reply With Quote
  #2  
Old 09-07-2014, 11:33 PM
expert4knowledge expert4knowledge is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Apr 2012
Posts: 59
expert4knowledge is on a distinguished road
Default

Black line is what I need.
Reply With Quote
  #3  
Old 09-09-2014, 06:27 AM
Jon Peltier Jon Peltier is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Mar 2012
Location: Massachusetts
Posts: 6
Jon Peltier is on a distinguished road
Default

Set up the data like this:

In the first column put the dates for your monthly data, then in the next few columns (as many as you need) put the monthly Y values.

Then in the first column, below the monthly dates, put the dates for the daily and weekly data. Don't bother sorting it, the chart will work out fine. In the column after the monthly Y values, and lined up with the daily and weekly dates, put the daily and weekly Y values.

Your data range will include empty cells, but that's not a problem.

Now select the data and create your chart. You will see some gaps in the lines, where the daily and weekly dates fall between monthly dates, but again, it's not a problem. Right click on the chart, choose Select Data. Click the Empty and Hidden Cells button in the bottom left of the dialog, and select the option to connect empty points with a line.
Reply With Quote
Reply

Tags
excel charts

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Over 7,000 Data Points Karen615 Excel 4 06-28-2011 10:08 AM
Can't select or edit chart data itguy PowerPoint 2 09-19-2010 10:13 AM
chart from large data set mcfie Excel 1 09-19-2010 03:11 AM
Making a bar chart with several data entries Blondie1966 PowerPoint 2 04-28-2010 03:00 PM
One bar chart for 3 sets of data rclloyd Excel 1 02-03-2006 09:51 AM


All times are GMT -7. The time now is 08:53 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft