Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating Pie Chart
I am new to creating charts. I have a worksheet with 12 budgets
(vertically). For each month's budget, I want to create a pie chart but have no clue how to. The categories (Credit Card, Ins-Life, Ins-Auto, Taxes, etc) are in column A. The amount for each line item is in column J. The range is from row 6 to row 55. I am not familiar with what the terminology is refering to. I don't know what Data Range is referencing (categories or amount?). I want to have a pie chart group all the likes together for a total amount spent. I appreciate your help and direction on what I need to do. Thanks, Les |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating Pie Chart
Select the cells in column A. Then, hold down the CTRL key and select the
cells in the column containing the data. In Excel 2007, click the Insert tab (if not already active) | appropriate chart button. In earlier versions of Excel, click the Chart Wizard button. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "WLMPilot" wrote: I am new to creating charts. I have a worksheet with 12 budgets (vertically). For each month's budget, I want to create a pie chart but have no clue how to. The categories (Credit Card, Ins-Life, Ins-Auto, Taxes, etc) are in column A. The amount for each line item is in column J. The range is from row 6 to row 55. I am not familiar with what the terminology is refering to. I don't know what Data Range is referencing (categories or amount?). I want to have a pie chart group all the likes together for a total amount spent. I appreciate your help and direction on what I need to do. Thanks, Les |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating Pie Chart
Thanks for your help. Now I have another problem.
The chart is created. However, my data contains categories that are duplicates. Example: CC (credit card) is listed four times for four different credit cards that are paid within each month. The pie chart list each CC individually instead of as a total for CC. How can I get the total for each CC? Les "Tushar Mehta" wrote: Select the cells in column A. Then, hold down the CTRL key and select the cells in the column containing the data. In Excel 2007, click the Insert tab (if not already active) | appropriate chart button. In earlier versions of Excel, click the Chart Wizard button. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "WLMPilot" wrote: I am new to creating charts. I have a worksheet with 12 budgets (vertically). For each month's budget, I want to create a pie chart but have no clue how to. The categories (Credit Card, Ins-Life, Ins-Auto, Taxes, etc) are in column A. The amount for each line item is in column J. The range is from row 6 to row 55. I am not familiar with what the terminology is refering to. I don't know what Data Range is referencing (categories or amount?). I want to have a pie chart group all the likes together for a total amount spent. I appreciate your help and direction on what I need to do. Thanks, Les |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating Pie Chart
Treat your data as the source for a PivotTable + PivotChart. While a chart
cannot perform a statistical summary, a PT can. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "WLMPilot" wrote: Thanks for your help. Now I have another problem. The chart is created. However, my data contains categories that are duplicates. Example: CC (credit card) is listed four times for four different credit cards that are paid within each month. The pie chart list each CC individually instead of as a total for CC. How can I get the total for each CC? Les "Tushar Mehta" wrote: Select the cells in column A. Then, hold down the CTRL key and select the cells in the column containing the data. In Excel 2007, click the Insert tab (if not already active) | appropriate chart button. In earlier versions of Excel, click the Chart Wizard button. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "WLMPilot" wrote: I am new to creating charts. I have a worksheet with 12 budgets (vertically). For each month's budget, I want to create a pie chart but have no clue how to. The categories (Credit Card, Ins-Life, Ins-Auto, Taxes, etc) are in column A. The amount for each line item is in column J. The range is from row 6 to row 55. I am not familiar with what the terminology is refering to. I don't know what Data Range is referencing (categories or amount?). I want to have a pie chart group all the likes together for a total amount spent. I appreciate your help and direction on what I need to do. Thanks, Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need help in creating a chart | Charts and Charting in Excel | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
Help creating a Chart | Excel Discussion (Misc queries) | |||
NEED HELP CREATING A CHART | Charts and Charting in Excel | |||
Creating a Pie Chart | Charts and Charting in Excel |