Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

*** Simple Muti-Series Line Graph ***

- - - - -

  • Please log in to reply
3 replies to this topic

#1
office13broken

office13broken

    Newbie

  • Member
  • 29 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

Goal: produce a line graph with these conditions

 

* multiple lines (series) of K

 

** going across the graph using X data (horizontal axis)

 

*** by Y (vertical axis)

 

i don't know what to look for. the information out there is a mess, and it's hard to separate the garbage from the quality, so i really really prefer a link to a guide/article/video. if you could link that, it would be great

there are many ways to do this, but is the best way?

excel 2010, win




How to remove advertisement from MSFN

#2
office13broken

office13broken

    Newbie

  • Member
  • 29 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

to make it simplier -- how do you make a muti-line chart?



#3
office13broken

office13broken

    Newbie

  • Member
  • 29 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

it's like http://www.telerik.c...ple-example.png -- only it has a lot of lines



#4
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,593 posts
  • Joined 23-July 04
  • OS:none specified
  • Country: Country Flag

Excel 2010 ?

I thought you were about Office 2013 (and a broken one ;)) . :unsure:

 

This is related to Excel 2013:

http://peltiertech.c...2013-xy-charts/

 

But the principles are the same.

A series suitable for an XY "scatter" chart needs to be made out of both X and Y values.

Normally you have a "same" interval for the X values and one interval of Y values for each series, but nothing prevents you for having "single" X and Y intervals for each one of the series.

 

jaclaz






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users