Pie Chart for each row.

  • Thread starter Thread starter okschlaps
  • Start date Start date
O

okschlaps

Is it possible to have a chart for each row in a worksheet and have it linked
to that row.
My situation is:
I have the following columns
Employee Pay Benefits

I want a pie chart for each row, so that when I select a row I see the
corresponding chart. Or if there's a way to capture the chart and embed it in
a cell, that would be fine, too.
I'm importing the data into Publisher which apparently doesn't have any
capacity for creating charts.

Thanks for your help.
 
Hi,

The answer is yes. If the data started in A1 and went to M7 you would
create a formula like the one below and have it update by pressing F9 or
using a little VBA.


=IF(OR(CELL("row")>7,CELL("row")=1),"",INDIRECT(ADDRESS(CELL("row"),COLUMN(A1))))

I can send you a sample spreadsheet if you like.
 
Hi,

Sorry to take so long, but I had a very long workday yeasterday. I've
forgotten how this is done here, let me check.
 
Hi,

I've ask where to post these but didn't get an answer that I could use. One
may come, but if you are in a hurry send me an email at
(e-mail address removed).

Thanks,
Shane Devenshire
 
Hi - this sounds like the same problem I have. Was there a solution that I
could try please?
 
Hi - this sounds like the same problem I'm having at the moment. Did you have
a solution to this that I could try please? (I have tried to email Shane at
the address shown, but might be breaking some sort of forum rules by going
direct?)
 
Hi - this sounds like the same problem I have. Was there a solution that I
could try please?
 
Back
Top