Chart

[Dave]

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]

Really struggling here. I want to create a leaderboard chart. I hav
names in
A2 - A10 and then Weeks from B1 - B53 and then accumalative values i
the
corresponding cells.

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

Thanks

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

 

[Luke M]

It sounds like you want to make a waterfall chart. Check out Jon's article:

http://peltiertech.com/Excel/Charts/Waterfall.html

 

[Dave]

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

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

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

Microsoft Office Help

.