Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Using Excel 2000
I am attempting, what is fast becoming apparent to be a lifetime study, to learn about PivotTables/PivotCharts - they are powerful and facinating. I am not a novice with Excel. However, no matter the dataset or configuration of resulting array; whether attempting chart after table has been created or selecting "PivotChart (with PivotTable) at the beginning, when attempting to create a pivot chart from my data this error occurs: "Cannot apply the default chart type to the selected data." I cannot find an "option" or configuration that would disallow creation of charts or change "default chart type". So, are there any ideas as to what the problem may be - user brain fart notwithstanding? TIA |
#2
![]() |
|||
|
|||
![]()
Found the problem: somehow the "Set as Default Chart" got changed to
something beside "BarChart" - ARGH! "user brain fart category" :-) "doco" wrote in message ... Using Excel 2000 I am attempting, what is fast becoming apparent to be a lifetime study, to learn about PivotTables/PivotCharts - they are powerful and facinating. I am not a novice with Excel. However, no matter the dataset or configuration of resulting array; whether attempting chart after table has been created or selecting "PivotChart (with PivotTable) at the beginning, when attempting to create a pivot chart from my data this error occurs: "Cannot apply the default chart type to the selected data." I cannot find an "option" or configuration that would disallow creation of charts or change "default chart type". So, are there any ideas as to what the problem may be - user brain fart notwithstanding? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot chart format | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
How do I create a custom scroll bar on a 3D Pivot Chart? | Charts and Charting in Excel |