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

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

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

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