Pie Chart for each row.
 

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.

Pie Chart for each row.
 

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(AD DRESS(CELL("row"),COLUMN(A1))))

I can send you a sample spreadsheet if you like.
--
Cheers,
Shane Devenshire


"okschlaps" wrote:

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.

Pie Chart for each row.
 

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

"ShaneDevenshire" wrote:

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(AD DRESS(CELL("row"),COLUMN(A1))))

I can send you a sample spreadsheet if you like.
--
Cheers,
Shane Devenshire


"okschlaps" wrote:

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.

Pie Chart for each row.
 

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.
--
Thanks,
Shane Devenshire


"okschlaps" wrote:

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

"ShaneDevenshire" wrote:

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(AD DRESS(CELL("row"),COLUMN(A1))))

I can send you a sample spreadsheet if you like.
--
Cheers,
Shane Devenshire


"okschlaps" wrote:

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.

Pie Chart for each row.
 

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
.

Thanks,
Shane Devenshire


"okschlaps" wrote:

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.

Pie Chart for each row.
 

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

"ShaneDevenshire" wrote:

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
.

Thanks,
Shane Devenshire


"okschlaps" wrote:

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.

Pie Chart for each row.
 

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

"ShaneDevenshire" wrote:

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
.

Thanks,
Shane Devenshire


"okschlaps" wrote:

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.

Pie Chart for each row.
 

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

"ShaneDevenshire" wrote:

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
.

Thanks,
Shane Devenshire


"okschlaps" wrote:

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.

Pie Chart for each row.
 

Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Stormy" wrote:

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

"ShaneDevenshire" wrote:

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
.

Thanks,
Shane Devenshire


"okschlaps" wrote:

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.