Q: Charting with two variables on the Y-axis

Mark -

Make your chart with satisfaction values. Then use Rob Bovey's Chart
Labeler (http://appspro.com) or John Walkenbach's Chart Tools
(http://j-walk.com), both free addins, to apply the labels in the votes
range to the satisfaction lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:
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


-----Original Message-----
Mark -

Make your chart with satisfaction values. Then use Rob
Bovey's Chart
Labeler (http://appspro.com) or John Walkenbach's Chart
Tools
(http://j-walk.com), both free addins, to apply the
labels in the votes
range to the satisfaction lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:
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


.

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:

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



-----Original Message-----
Mark -

Make your chart with satisfaction values. Then use Rob

Bovey's Chart

Labeler (http://appspro.com) or John Walkenbach's Chart

Tools

(http://j-walk.com), both free addins, to apply the

labels in the votes

range to the satisfaction lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:

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


.

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

-----Original Message-----
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:

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



-----Original Message-----
Mark -

Make your chart with satisfaction values. Then use Rob

Bovey's Chart

Labeler (http://appspro.com) or John Walkenbach's Chart

Tools

(http://j-walk.com), both free addins, to apply the

labels in the votes

range to the satisfaction lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:

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


.


.

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:

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


-----Original Message-----
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:


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




-----Original Message-----
Mark -

Make your chart with satisfaction values. Then use Rob

Bovey's Chart


Labeler (http://appspro.com) or John Walkenbach's Chart

Tools


(http://j-walk.com), both free addins, to apply the

labels in the votes


range to the satisfaction lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:


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


.


.

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

-----Original Message-----
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

MarkD wrote:

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


-----Original Message-----
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______