Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2003

Tip: Looking for answers? Try searching our database.

grafic with two different variavels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ana Nakamura - 30 Nov 2003 06:43 GMT
Hi dear all,

I  will try to explain what is puting me crasy.

I have the quantity of ATM which I have to combine with  
each cities I have. To do this grafic is not that
complicated, but I also have to input another variavel and
compare with the number of Brazilian in each city. How can
I put this different variavel in the same grafic? I would
thank you a lot if you show me the way to this, step by
step. I also would like to sorry for my unnable to do that
so.

Ana.
Jon Peltier - 30 Nov 2003 16:59 GMT
Ana -

There are a few different ways you could do this.  Start with your data
in three columns.  Leave Cell A1 blank, type ATMs in B1, and type
Brazilians in C1.  List your cities below A1, and in the same row as the
city, list the number of ATMs and of Brazilians.  Like this, only with
real numbers:

             ATMs    Brazilians
Brasilia     1500      2000000
Rio          2100      1250000
Sao Paolo    1250      1750000

Select the range of data (including the top row), start the chart
wizard, and on step 1, you might want a chart type like Lines On Two
Axes, on the Custom tab.  This puts the ATM number on the left hand
axis, and the population on the right.  If you make a line chart on just
one axis, you can move a series to the second axis by double clicking it
and selecting Secondary on the Axis tab.

Another way to show this would be to select just the data in columns B
and C, and make a Scatter chart.  This shows how the number of ATMs
varies with population.  If you know ahead of time that you want
population on the X axis, switch columns B and C in the data before
making the chart.  If you want to switch X and Y after making the chart,
right click the chart, choose Source Data from the pop up menu, click on
the Series tab, select the series, and switch what's in the Y Values and
X Values boxes (copy-paste or selecting with the mouse).

A scatter chart shows part of the picture, but it's even better if you
label the points, to know which city corresponds to which point.  You
can do this manually, and you'll become easily bored.  Fortunately,
there are a couple useful and free Excel addins that can automatically
label data points, using labels in a worksheet range:
    Rob Bovey's Chart Labeler, http://appspro.com
    John Walkenbach's Chart Tools, http://j-walk.com
Download and install one of these, and use it to apply the city names in
column A to the points in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> Hi dear all,
>
[quoted text clipped - 10 lines]
>
> Ana.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.