Thread
:
multiple x-axis data
View Single Post
#
1
Posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
Posts: 6,582
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
Reply With Quote
Jon Peltier
View Public Profile
Find all posts by Jon Peltier