Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
Excel chart - how to assign the file name in the chart title? | Charts and Charting in Excel |