Q: Charting with two variables on the Y-axis

  • Thread starter Thread starter MarkD
  • Start date Start date
M

MarkD

Using Excel 2000:

Hey all,

I have two tables and want a line graph based on one row,
but with the values of another row:


Votes:
------
Region1: 10, 10, 15
Total: 50, 60, 100

Satisfaction Rates:
-------------------
Region1: 60%, 80%, 45%
Overall: 50%, 90%, 50%

I want a line graph that compares the satisfaction rates
of region 1 vs. overall (ie, it will show two lines, one
for region1, one for overall). That's pretty
straightforward. However, what I also want is, for
Region1, to show the vote counts as values above (or
below) the datapoints for the region 1 line.

Can this be done, and if so, how?

Thanks!
-Mark
 
Thanks Jon,

I'll have to keep those websites (as well as yours) in
mind. Unfortunately, my company won't allow me to install
addins -- go figure.

-Mark
 
Mark -

Another example of the way that many IT departments exist to make their
employees jobs harder. You don't need to install an add in, though, you
can just run it like a regular program. Do they let you use floppy disks?

- Jon
 
I would imagine, though, that in order for others to see
the spreadsheet, they would also have to get the addin,
right? If that's the case, then I can't do that.

I agree with you about the IT restrictions and it's not
the first time. I needed an addin for FTPing in Access and
couldn't get that addin either. Oh well.

-Mark
 
No, the addin puts the labels into your chart. Someone without the addin
can still see them once you've put them there.

How do they prevent addins?

- Jon
 
Hey Jon,

Well, if only I need the add-in, that may be easier to get
across to my boss.

As for how they prevent adding addins, they really don't
have a way to restrict it, it's just policy that I don't
want to bypass as it could get me terminated just on
principle.

Working in a smaller company was great; I could add
whatever I wanted. But I now work for a huge company.

Thanks for all your help!
-Mark
 
Corporate intelligence is like committee intelligence. It's proportional
to 1/N. Unfortunately, even though policies were made to be broken,
there are repercussions.

Do they let you record macros? My old company used to send a guy around
deleting personal.xls, until we threatened to kill the guy. They must
have though one of us wrote the leroux virus.

- Jon
 
Back
Top