Pivot Chart: cannot apply the default chart type...

D

doco

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
 
D

doco

Found the problem: somehow the "Set as Default Chart" got changed to
something beside "BarChart" - ARGH!

"user brain fart category" :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot apply the default chart type to the selected data 1
Chart Template Default Directroy excel 2007 1
Chart Type changes when I pivot 1
Pivot Chart affected when refresh data 1
Pivot Chart - default chart type 4
When refreshing pivot tables my pivot table chart type changes 1
Pivot Chart VBA Reformat 1
XY Scatter Pivot Chart in Excel 2000 2

Top