multiple x-axis data
 

I have a chart with time on the Y axis, and on the left axis electrical
consumption, and the right axis # of people in a building. I am showing the
effect of an increase in people and how it affects the electrical usage (both
go up). I have found by adcjusting the min/max values on either or both
x-axis it can make the data visually look better or worse, it skews it. How
would I make the data "proper" or acurate from a visual sense maybe
standardize it somehow. Make the min values 0?
Thanks

multiple x-axis data
 

Jeff McW

I am having a problem visualizing your chart.

You say that you are plotting time on Y axis. Do you really mean X axis?
What are units, years, months, days?

You say that you have electrical consumption on left axis. Isn't this the
primary Y axis?

You then say that you have population on right axis. Isn't this the
secondary Y axis.

I can make some sense of your description if you have time on X axis,
Electrical consumption Y primary and population on Y secondary.

Is this how you have your chart axes organized?

I suggest that you describe your chart more fully so that we can understand
what you have. Is it a trend chart with two Y axes?


...Kelly






"Jeff McW" <Jeff wrote in message
...
I have a chart with time on the Y axis, and on the left axis electrical
consumption, and the right axis # of people in a building. I am showing
the
effect of an increase in people and how it affects the electrical usage
(both
go up). I have found by adcjusting the min/max values on either or both
x-axis it can make the data visually look better or worse, it skews it.
How
would I make the data "proper" or acurate from a visual sense maybe
standardize it somehow. Make the min values 0?
Thanks

multiple x-axis data
 

You are right...long day! Swap x and y. I have time on the x (months) and
the other two sets of data on the Y's (left and right)

Jeff

"Kelly O'Day" wrote:

Jeff McW

I am having a problem visualizing your chart.

You say that you are plotting time on Y axis. Do you really mean X axis?
What are units, years, months, days?

You say that you have electrical consumption on left axis. Isn't this the
primary Y axis?

You then say that you have population on right axis. Isn't this the
secondary Y axis.

I can make some sense of your description if you have time on X axis,
Electrical consumption Y primary and population on Y secondary.

Is this how you have your chart axes organized?

I suggest that you describe your chart more fully so that we can understand
what you have. Is it a trend chart with two Y axes?


...Kelly






"Jeff McW" <Jeff wrote in message
...
I have a chart with time on the Y axis, and on the left axis electrical
consumption, and the right axis # of people in a building. I am showing
the
effect of an increase in people and how it affects the electrical usage
(both
go up). I have found by adcjusting the min/max values on either or both
x-axis it can make the data visually look better or worse, it skews it.
How
would I make the data "proper" or acurate from a visual sense maybe
standardize it somehow. Make the min values 0?
Thanks

multiple x-axis data
 

If you want to show the effect of number of people on electrical
consumption, you should plot number of people as your X variable and
electrical consumption as your Y.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jeff McW" <Jeff wrote in message
...
I have a chart with time on the Y axis, and on the left axis electrical
consumption, and the right axis # of people in a building. I am showing
the
effect of an increase in people and how it affects the electrical usage
(both
go up). I have found by adcjusting the min/max values on either or both
x-axis it can make the data visually look better or worse, it skews it.
How
would I make the data "proper" or acurate from a visual sense maybe
standardize it somehow. Make the min values 0?
Thanks