+ Reply to Thread
Results 1 to 3 of 3

Charting Multiple Data Series Using ONE Selection?

Hybrid View

  1. #1
    Registered User
    Join Date
    04-15-2012
    Location
    Dupage County, IL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Charting Multiple Data Series Using ONE Selection?

    I would like to create a chart with 2 or more data series selections. These series' would be identical but offset by a specific distance along the horizontal axis. I currently create multiple columns to derive each selection from. The data is simply shifted by a given number of rows to create the offset with regard to time. This is the most accurate way I know of to maintain the correct separation of each series but is time consuming to update the chart.
    It seems there must be a way to make just one selection of the data for a given chart > create multiple instances of the selection > offset each instance as required for proper time separation along the H axis.
    I use the term 'offset' but I do not know if it would be used here.
    I can attach a sheet if Im not being clear enough here. Im just assuming its a rather simple task.
    Thank you.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Charting Multiple Data Series Using ONE Selection?

    Hi and welcome to the forum.

    It is best to upload a sample workbook (cutdown version with dummy data but exact structure).
    Include a clear and explicit explanation of your requirements and show an example of the desired results.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    04-15-2012
    Location
    Dupage County, IL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Charting Multiple Data Series Using ONE Selection?

    Thanks for your interest Palmetto.

    The file I have attached: Data in Col. B is replicated in C & D, but occupying a later date respectively. I selected BCD as a group to create the chart, which formats as desired. I would like to avoid the existence of Cols. C and D altogether, yet still create the same 3 series chart. Can I format a chart this way(ie. 3 series' separated by 10 days) but only make one data selection from Col. B?

    My goal is to easily update this chart without selecting each series individually and enlarging the selection to include new data.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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