#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Black line is what I need.
|
#3
|
|||
|
|||
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. |
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 |