+ Reply to Thread
Results 1 to 18 of 18

is it possible to have 2 different charts in one chart

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    is it possible to have 2 different charts in one chart

    Hello everyone, I want to know if it is possible to have 2 different charts with different data sources in one chart?
    Last edited by expert4knowledge; 09-08-2014 at 06:03 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,098

    Re: is it possible to have 2 different charts in one chart

    yes, for certain chart type combinations
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    Re: is it possible to have 2 different charts in one chart

    How can we do it? I mean to have 2 different charts with different data ranges?
    BTW you have a great website and it is a great manual for charts

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,098

    Re: is it possible to have 2 different charts in one chart

    For xl2003 see this article.
    http://office.microsoft.com/en-gb/ex...329.aspx?CTT=1

    If you provide more detail about what you are actually doing we can provide more specific answers.

  5. #5
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    Re: is it possible to have 2 different charts in one chart

    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? Something like black line.image001.jpg In fact I have posted it in another forum have not received any response yet.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,098

    Re: is it possible to have 2 different charts in one chart

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    If all your data sets have dates and values use xy-scatter to plot all series.

    FYI, It's much more helpful to post example workbook rather than picture.

  7. #7
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    Re: is it possible to have 2 different charts in one chart

    sure, I want to close the other forum post, how can I do it?

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,098

    Re: is it possible to have 2 different charts in one chart

    If it's another forum site you will need to deal with their admin.

  9. #9
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    Re: is it possible to have 2 different charts in one chart

    I asked them, how can I get answer of my question about drawing the chart.

  10. #10
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,098

    Re: is it possible to have 2 different charts in one chart

    ??? don't understand.

    I assumed you had asked the same question in 2 places. If you want to close the other thread that is up to you but you will need to deal with the admin people on that site in order to get it closed. Or you could just do what it says in the message about cross posting, which is to include links to both articles.

  11. #11
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    Re: is it possible to have 2 different charts in one chart

    Yes, I asked the admin in the other forum to close my question since I am talking about it here, that's all, sorry for this, I did not know these. I checked it, it was in mrexcel.com and it deleted now
    Last edited by expert4knowledge; 09-08-2014 at 08:33 AM.

  12. #12
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    Re: is it possible to have 2 different charts in one chart

    Here is the file, in the graphs sheet, it is what is current status and in the sheet1, you can see a try of me.
    Last edited by expert4knowledge; 09-08-2014 at 01:26 PM.

  13. #13
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,098

    Re: is it possible to have 2 different charts in one chart

    No attachment

  14. #14
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    Re: is it possible to have 2 different charts in one chart

    It is there now.

  15. #15
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,098

    Re: is it possible to have 2 different charts in one chart

    As suggested, use xy-scatter and NOT line chart. By doing so you can define data range for each series.
    Attached Files Attached Files

  16. #16
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    Re: is it possible to have 2 different charts in one chart

    Quote Originally Posted by Andy Pope View Post
    As suggested, use xy-scatter and NOT line chart. By doing so you can define data range for each series.
    Thanks Andy, you are majestic, let me know how can I compensate your help plz.

  17. #17
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: is it possible to have 2 different charts in one chart

    No, it's easy enough to do with a line chart, as I answered in the other forum.

    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.
    Jon Peltier
    http://PeltierTech.com/

  18. #18
    Registered User
    Join Date
    11-15-2012
    Location
    HereNear
    MS-Off Ver
    Excel 2007 for windows
    Posts
    13

    Re: is it possible to have 2 different charts in one chart

    Thanks Jon.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can I make the data ranges displayed in a chart vary depending on my no. of data points
    By David Myers in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-06-2014, 02:16 PM
  2. Selecting chart data ranges
    By Jonathan78 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-23-2010, 06:37 AM
  3. Named Data Ranges & Chart
    By Luignata in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-14-2008, 12:50 PM
  4. bar chart with multiple data ranges?
    By zentaur in forum Excel General
    Replies: 1
    Last Post: 11-15-2006, 02:40 AM
  5. [SOLVED] Combination chart with three data ranges
    By Joe Mac in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-11-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1