Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Chart

0 views
Skip to first unread message

Dave

unread,
Nov 25, 2009, 7:03:02 AM11/25/09
to
Really struggling here. I want to create a leaderboard chart. I have names in
A2 - A10 and then Weeks from B1 - B53 and then accumalative values in the
corresponding cells.

How do i create a bar chart to show the values going up week by week?

Thanks

p45cal

unread,
Nov 25, 2009, 8:22:47 AM11/25/09
to

These two ranges are both columns. Is that what you meant? It's
difficult to see where the 'corresponding cells' might be.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=157120

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

Luke M

unread,
Nov 25, 2009, 8:34:02 AM11/25/09
to
It sounds like you want to make a waterfall chart. Check out Jon's article:

http://peltiertech.com/Excel/Charts/Waterfall.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Dave

unread,
Nov 25, 2009, 10:24:01 AM11/25/09
to
Hi,

The columns contain values in weeks ascending i.e. B1 = week 1 B2 = (4000)
C1 = week 2 C2 = (8000) etc. The rows are for employees names i.e. A2 JON
SMITH, A3 JOE BLOGGS etc

Hope this makes sense.

Thanks

"p45cal" wrote:

> [url="http://www.thecodecage.com"]Microsoft Office Help[/url]
>
> .
>

0 new messages