ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Source Data Mess (https://www.excelbanter.com/charts-charting-excel/147538-source-data-mess.html)

Karen

Source Data Mess
 
Using Excel 2003
I created one pie chart and then did a copy & paste to paste that same chart
into another worksheet. Then I right-clicked and chose €śSource Data€ť and
then highlighted the data for the new chart with the new raw data. Theres
one problem €“ The data labels and the corresponding percentages pasted over,
but the pieces of the pie chart do not correspond to their data labels.
Theres a piece of the pie that is supposed to be 49% and its about half of
what it should be. I hope I explained this properly. Does anyone know why
this is happening?

ANY help would be greatly appreciated, Karen


FloMM2

Source Data Mess
 
Karen,
Try this:
Select the "new" chart by right mouse click to select it.
Then select "Source Data" and put the original Pie chart data (from first
chart).


"Karen" wrote:

Using Excel 2003
I created one pie chart and then did a copy & paste to paste that same chart
into another worksheet. Then I right-clicked and chose €śSource Data€ť and
then highlighted the data for the new chart with the new raw data. Theres
one problem €“ The data labels and the corresponding percentages pasted over,
but the pieces of the pie chart do not correspond to their data labels.
Theres a piece of the pie that is supposed to be 49% and its about half of
what it should be. I hope I explained this properly. Does anyone know why
this is happening?

ANY help would be greatly appreciated, Karen



All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com