Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Chart
I am trying to learn how to do a pie chart. I used the Chart Wizard, but not
getting the data I want. I have a statistical page that gathers data from another worksheet regarding paychecks. Below is a general layout: Payck1 Payck2 Payck3 Reg Pay OT Pay Vacation TOTAL GROSS Fed Tax State Tax TOTAL TAX With this layout, I can total each section for each paycheck AND total each row, ie TOTAL FEDERAL TAXES. I want to chart the percentage of each row, IE % Fed Tax, % State Tax, etc in a pie chart. NOTE that on the row that there is "TOTAL", there is also a TOTAL percentage of that section, ie % of TOTAL TAXES. The problem is chart wizard will indicate an entire column as the data, which will include the totals. I don't want the totals included in the pie chart, just the individual row (item). How do I tell chart wizard to overlook the row that has the totals? Thanks, Les |
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 | |||
Chart Titles not showing in excel chart Window | Excel Discussion (Misc queries) | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel |