How to create ONE graph with a growth trend ($ and %)?

Question

Level 1

0 points

How to create ONE graph with a growth trend ($ and %)?

I would like to create a graph with a growth trend.

The graph should have figures on one side reflecting $ values and on the other % growth.

I cannot make a trend on the same graph and usually spend ages adding another graph to show the trend. I end up making 2 graphs instead of one.

Please refer to the following really basic graph that will give you an idea.

ex : http://www.tellurideareahomes.com/images/graph1.jpg

Can anyone show how to do that?

imac, Mac OS X (10.5.5)

Posted on Nov 18, 2008 6:46 PM

Reply

Answer 1

KOENIG Yvan

Level 8

41,819 points

Nov 19, 2008 2:19 AM in response to i톰

What you want requires a bit of trickery.

Chart the bar graph
Chart the trend
then move the trend one above the bar one after setting its background to none.

If this workaround is not OK for you,

_Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
Then, cross your fingers, and wait _at least_ for iWork'09 (possibly for iWork '99) 😉

Yvan KOENIG (from FRANCE mercredi 19 novembre 2008 11:18:45)

Reply

Answer 2

i톰 Author

Level 1

0 points

Nov 20, 2008 3:51 PM in response to KOENIG Yvan

Merci Yvan. That is what did so far, i thought that Numbers had an option as it s a basic function for business consultancy. For once, excel does a better job .^^.

Thanks.

Reply

Answer 3

KOENIG Yvan

Level 8

41,819 points

Nov 21, 2008 9:49 AM in response to i톰

i톰 wrote:
Merci Yvan. That is what did so far, i thought that Numbers had an option as it s a basic function for business consultancy.

Thanks for the feedback.

I'm not sure that Numbers was designed to fit the needs of this kind of activity 😉

Yvan KOENIG (from FRANCE vendredi 21 novembre 2008 18:49:18)

Reply