# How do I specify X,Y axis and Series values in a line graph?

D

#### Diff-edge

I have a problem where I need to specify the values for the x and y axis as
well as specifying the values for the lines/series information.

Currently all I can do is specify either both x & y axis via a scatter Graph
or one axis and the Series values via a line Graph.

Any suggestions?

J

#### Jon Peltier

I don't understand your question. What do you mean by Series values?

- Jon

D

#### Diff-edge

"Series" is the term excel uses, but by it I am referring to the specific
information that makes up the line or lines in a line Graph.

J

#### Jon Peltier

For each series in a line chart, you specify category labels (X values), Y
values, and a series name. The category labels (X values) are shared among
the series in the line chart.

For each series in an XY chart, you specify X values, Y values, and a series
name. Sometimes the X values are shared among multiple series, but they
don't need to be.

This is all very general. Maybe if you describe your difficulty more
specifically, it would be easier for someone to visualize a way to help.

- Jon

D

#### Diff-edge

I need, to specify my own parameters (X and Y axis values) as well as my line
values.

For example, I have my x axis = Temp
Series (lines) are values I measured at a specific temp to give me a
measurement on a specific scale.

They Y axis is the scale I need but it has ranges. For example 50-90 is one
scale and 10-45 is another scale which has a higher value than the previous
scale.

My measurements cross over between both scales. Therefore I need to specify
my y values myself.

J

#### Jon Peltier

This is what it sounds like you're asking for:

You have some Y data between 50 and 90, and other Y data between 10 and 45,
and the 10 to 45 should be in a panel which is above the 50 to 90 panel.

You can make a panel chart, and generate different scales for each panel:
http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html

- Jon