PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Data Series Name issue making a Chart from a PivotTable

Reply

Data Series Name issue making a Chart from a PivotTable

 
Thread Tools Rate Thread
Old 18-11-2007, 10:16 AM   #1
=?Utf-8?B?TWFyY28gUnVzc28=?=
Guest
 
Posts: n/a
Default Data Series Name issue making a Chart from a PivotTable


Making a chart from a PivotTable having a single column of data (a single
data series) I get always "Total" as a data series name. Using two or more
measures in the Pivot Table results in multiple Data Series, having each one
the right name (corresponding to the measure name as displayed in the header
of the PivotTable).
Repro is very easy:
- create a pivot table with two measures on columns and a time series on rows
- insert a chart selecting the pivot table
- you will see two data series with name corresponding to pivot table column
names (measure names)
- remove a measure from the pivot table: the chart will be updated renaming
the remaining measure to "Total"
- at this point there is no way to rename "Total" in another name.

Is this a bug or a "by design" feature? :-)

Marco Russo
http://www.sqlbi.eu
http://sqlblog.com/blogs/marco_russo
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off