Pie Chart for each row.

[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.

 

[ShaneDevenshire]

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.

 

[okschlaps]

thanks so much Shane
A Worksheet would be great.
Do I just post my email address?

 

[ShaneDevenshire]

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.

 

[ShaneDevenshire]

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

 

[Stormy]

Hi - this sounds like the same problem I have. Was there a solution that I
could try please?

 

[Stormy]

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?)

 

[Stormy]

Hi - this sounds like the same problem I have. Was there a solution that I
could try please?

 

[Shane Devenshire]

Hi,

I posted my email address so its ok to send a sample of you data to me.