• Announcements

    • xper

      MSFN Sponsorship and AdBlockers!   07/10/2016

      Dear members, MSFN is made available via subscriptions, donations and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, become a site sponsor and ads will be disabled automatically and by subscribing you get other sponsor benefits.
Sign in to follow this  
Followers 0
office13broken

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

4 posts in this topic

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

0

Share this post


Link to post
Share on other sites

Excel 2010 ?

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

This is related to Excel 2013:

http://peltiertech.com/WordPress/intelligent-excel-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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.