+ Reply to Thread
Results 1 to 1 of 1

how on earth do i chart this (in some userfriendly easy-ish way!)

Hybrid View

  1. #1
    Registered User
    Join Date
    07-08-2016
    Location
    earth
    MS-Off Ver
    2003, 2013
    Posts
    1

    how on earth do i chart this (in some userfriendly easy-ish way!)

    here's my data

    seriesName	x-value	y-value		seriesName	       x-values->	0	25	50	100	150	200	250
    1Y      	68	      30.8	                1Y 	                              	33.3	33.2	30.9	40.2	54	67.1	80.7
    2Y       	74	      46.9	            	2Y 	                              	40.1	43.7	44.8	51.4	59	66	72.2
    3Y 	      81	      57.9	               	3Y 	                              	58.6	57.2	56.2	60.2	65.4	69.9	74.4
    4Y 	      89	      66.6	               	4Y 	                              	68.2	66.3	65	67.6	71.9	75.8	79.9
    5Y 	      101	      72.7	            	5Y 	                              	74.3	72.4	71.1	72.9	76.4	79.9	83.4
    6Y 	      120	      77	            	6Y 	                               	78.3	76.6	75.3	76.6	79.4	82.4	85.5

    so, in a sense, you can describe it this way: there are 6 line charts, labeled 1y-6y. there are 8 points on each series. 7 of them have fixed x values , 1 of them has a varying x value.
    i want to chart a LINE chart , where only y-values at adjacent x-values are joined.


    i would want a big dot, in the same colour as the line of that series, for the point whose x-value varies.a1.png
    Last edited by 6StringJazzer; 07-08-2016 at 08:56 AM. Reason: used code tags to preserve spacing of sample data

+ 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. easy to use, feature-packed excel -> google earth kml maker. Come take a look!
    By mexindian in forum Excel Programming / VBA / Macros
    Replies: 44
    Last Post: 06-14-2016, 12:01 AM
  2. easy way to zoom into chart
    By chibiks in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-04-2015, 04:57 AM
  3. Easy Chart (for someone who knows what they are doing)
    By jasonjhc in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-17-2012, 07:13 AM
  4. Replies: 4
    Last Post: 06-29-2012, 09:41 AM
  5. Single Bar Chart - This should be easy, right?
    By eitherorr in forum Excel General
    Replies: 4
    Last Post: 06-19-2012, 02:48 PM
  6. make a combo box more userfriendly
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2011, 02:07 PM
  7. Excel to Google Earth made easy
    By rmpaternoster in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-07-2008, 08:05 AM

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