Changing values in a value box

[joshsackett]

Hi all,
I have a data set that looks like this:

DATE A$ B$ A% B%
mar-14 50 100 33 66
mar-21 100 100 50 50
mar-28 75 25 75 25

I want to chart the percentages by each date, but I want the "value"
box to display the dollars. The only way I can think to trick the Excel
chart is create 2 x-axises and hide the $ axis, but then the $ values
don't match the height of the % columns.

Is there a way to link the $ values to the % columns?

Thanks.

 

[Earl Kiosterud]

Josh,

To chart only the percentages, select the Date column, and also the two %
columns (drag through them holding Ctrl). I've read your statement about
the "value" box several times -- I can't guess what you mean.
--
Earl Kiosterud
www.smokeylake.com/

Off-topic: There's a hilarious comedy act by Men in Coats at
http://www.koreus.com/files/200505/men-in-coats.html. You gotta see this.
I had to share with all.

 

[joshsackett]

By "value" box I mean: When you go into the chart options you can click
to display the value for each column. That value is then displayed
above the columns.