Closed Thread
Results 1 to 2 of 2

Combine 2 data sets in one graph

  1. #1
    Registered User
    Join Date
    11-24-2019
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    8

    Combine 2 data sets in one graph

    Hello all,

    I am trying to get data from 2 different sheet in 1 line stacked line chart.
    It is working with the following code:

    .SeriesCollection.NewSeries
    'Value
    .SeriesCollection(1).Values = wsWaarde.Range(wsWaarde.Cells(W + 1, j + 1), wsWaarde.Cells(LaatsteCellWaarde, j + 1))
    'Date
    .SeriesCollection(1).XValues = wsWaarde.Range(wsWaarde.Cells(W + 1, j), wsWaarde.Cells(LaatsteCellWaarde, j))
    .SeriesCollection.NewSeries
    'Value
    .SeriesCollection(2).Values = wsGemiddelde.Range(wsGemiddelde.Cells(Z + 1, l + 9), wsGemiddelde.Cells(LaatsteCellGemiddelde, l + 9))
    'Date
    .SeriesCollection(2).XValues = wsGemiddelde.Range(wsGemiddelde.Cells(Z + 1, l), wsGemiddelde.Cells(LaatsteCellGemiddelde, l))

    The given data are values over time, in the first series (wsWaarde) every day there is a new value but in the second series (wsGemiddelde) there is just a new value once every couple of weeks/months.
    I want to combine those data in 1 chart. Now i got both data in 1 chart, but second series doesn't follow the time schedule on the horizotal axis.
    Can someone help me get the second series on the same time schedule?

    Thanks in advance

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Combine 2 data sets in one graph

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combine 2 data sets in one graph
    By Tamar1984 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-16-2020, 06:17 PM
  2. [SOLVED] Trying to combine two sets of data
    By bigball in forum Excel General
    Replies: 10
    Last Post: 01-30-2017, 09:03 PM
  3. Trying to combine two data sets to get one answer
    By b_rianv in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-25-2016, 02:42 PM
  4. Combine to sets of data
    By rlsmith789 in forum Excel General
    Replies: 2
    Last Post: 07-08-2014, 07:43 PM
  5. Combining a bar graph and line graph with 2 sets of data
    By lynzlou in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-11-2014, 12:49 AM
  6. [SOLVED] How to Combine two sets of data in excel
    By Jchhoule in forum Excel General
    Replies: 3
    Last Post: 05-10-2012, 02:47 PM
  7. Combine two sets of data
    By FrankCastle in forum Excel General
    Replies: 4
    Last Post: 08-15-2011, 06:31 PM

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