View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day Kelly O'Day is offline
external usenet poster
 
Posts: 103
Default 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