4-same-lines-in-one-graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I-have-one-graph-with-4-variables.The-values-of-the-variables-are-almost-similar.So-the-graph-with-X-axis-the-days-for-1-year-shows-4-same-lines,the-one-up-to-other.What-can-I-do-so-as-to-plot-the-values-and-and-show-the-lines-differently?

Thank-you-gor-any-information
NR
 
I-have-one-graph-with-4-variables.The-values-of-the-variables-are-almost-similar.So-the-graph-with-X-axis-the-days-for-1-year-shows-4-same-lines,the-one-up-to-other.What-can-I-do-so-as-to-plot-the-values-and-and-show-the-lines-differently?
Click to expand...

Wow, that's hard to read!

A very similar question was posted to the ms.pub.xl.charting newsgroup
earlier today. There are two replies that you might wish to peruse. Here
is a copy of my reply to that query:

I suspect you could use a broken axis for your purpose. In your case,
your axis might span 1-3 in the first part, then 1-3 again in the last
section. A broken axis is normally used to display values that are very
different, but there's no law that states this must be so.

To learn how to make a broken axis, see Tushar's site
(www.tushar-mehta.com). Look for Broken Y Axis on the left. Or try Jon's
site (http://www.geocities.com/jonpeltier/Excel/Charts/axes.html#Broken)..
 
Back
Top