Results 1 to 11 of 11

How do I add the time dimension in a XY scatter or bubble plot?

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2013
    Location
    Greece
    MS-Off Ver
    Excel 2007
    Posts
    6

    How do I add the time dimension in a XY scatter or bubble plot?

    Dear all,

    I am trying to plot the combination of "b" and "c" series as a time trend.... Using the option of XY scatter or bubble plot, I assign the x and y values in each point. But I can never get them in time sequence because they end up appearing according to the values. I tried to activate the secondary x axis option, but it is not somehow available. Any ideas please?? Im using Excel 2007. Thanking you in advance...

    Time b c
    2008 278,08 341,96
    2009 271,26 331,43
    2010 278,89 343,85
    2011 302,17 357,87
    2012 305,11 305,98
    2013 311,39 307,36
    2014 319,71 309,94
    2015 329,31 314,49
    2016 339,69 315,49
    2017 350,56 317,05
    Last edited by kyr; 05-19-2013 at 07:57 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1