+ Reply to Thread
Results 1 to 3 of 3

Merging two different data sets into one chart

Hybrid View

  1. 11-25-2012, 10:27 PM #1
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,330

    Re: Merging two different data sets into one chart

    Hi brijendar and welcome to the forum,

    There is a tool that is no longer on the toolbar called the Pivot Table Wizard that allows what you want.
    Read http://www.pivot-table.com/2010/07/1...in-excel-2007/ on how to put it on your toolbar and then http://office.microsoft.com/en-us/ex...010226585.aspx to see how to use your two ranges to get what I think you want.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  2. 11-26-2012, 06:47 PM #2
    brijendar
    brijendar is offline
    Registered User
    Join Date
    11-25-2012
    Location
    Wellington
    MS-Off Ver
    excel 2007
    Posts
    2

    Re: Merging two different data sets into one chart

    Hi Marvin,

    Thanks for your reply.
    I tried using Pivot Tables before writing this query but they did not quite work. Fortunately I figured a way out and its all good now.

    Thanks for your help anyway.

    Thanks,
    BJ
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1