Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Source Data in Chart
Using Excel 2002
I created a pie chart on one sheet tab (Sheet1). I have 10 tabs of raw data. The data resides on their respective tabs. I want to use the same chart and format for each tab. I copied the chart from Sheet1 and pasted it to Sheet2. Then I right-clicked on the Sheet2 chart and changed the source data to refelct the data on sheet2. Is this a glitch or somethin? It doesn't update my data labels correctly. The percentages are wrong and it keeps the same category names from the Sheet1 chart. How can this be fixed so I don't have to recreate the chart each time? Thank you, Karen |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Source Data in Chart
The following technique is more reliable. Assuming Sheet1 is the sheet with
data and a chart, copy Sheet1 and it will be named Sheet1 (2), then copy the data from Sheet2 and paste it into the same cells of Sheet1 (2). Sheet1 (2) will then contain a chart with the updated data that was pasted from Sheet2. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ .. "Karen" wrote in message ... Using Excel 2002 I created a pie chart on one sheet tab (Sheet1). I have 10 tabs of raw data. The data resides on their respective tabs. I want to use the same chart and format for each tab. I copied the chart from Sheet1 and pasted it to Sheet2. Then I right-clicked on the Sheet2 chart and changed the source data to refelct the data on sheet2. Is this a glitch or somethin? It doesn't update my data labels correctly. The percentages are wrong and it keeps the same category names from the Sheet1 chart. How can this be fixed so I don't have to recreate the chart each time? Thank you, Karen |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Source Data in Chart
Thank you for your help
I followed what you told me to do, but it's not working for me. I must be a jinx! :) This may be a problem and I forgot to mention it in my previous posting. All the sheets have different amounts of data. Sheet1 has 4 values and Sheet2 has 9. So, what I did just to check it, I only copied the same amount of values from one sheet to the next and it didn't update my Data Label (Category Name) - Actually it has the same percentages and data labels. Not surw what I did wrong. Thanks again, Karen "Jon Peltier" wrote: The following technique is more reliable. Assuming Sheet1 is the sheet with data and a chart, copy Sheet1 and it will be named Sheet1 (2), then copy the data from Sheet2 and paste it into the same cells of Sheet1 (2). Sheet1 (2) will then contain a chart with the updated data that was pasted from Sheet2. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ .. "Karen" wrote in message ... Using Excel 2002 I created a pie chart on one sheet tab (Sheet1). I have 10 tabs of raw data. The data resides on their respective tabs. I want to use the same chart and format for each tab. I copied the chart from Sheet1 and pasted it to Sheet2. Then I right-clicked on the Sheet2 chart and changed the source data to refelct the data on sheet2. Is this a glitch or somethin? It doesn't update my data labels correctly. The percentages are wrong and it keeps the same category names from the Sheet1 chart. How can this be fixed so I don't have to recreate the chart each time? Thank you, Karen |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Source Data in Chart
Check out the series formula in the copied chart. Select a series and look
in the formula bar. You should see a formula like this: =SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$10,Sheet1!$B$2: $B$10,1) If you don't see cell references, or references to a defined name, something may have happened to the chart. For example, in Excel 2003 and earlier, if you copy a chart or the sheet it's on, and the chart was defined with worksheet-level names, the sheet-level names are likely to be converted into static arrays. Workbook-level names are okay (although there is some funny business with them in 2007). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Karen" wrote in message ... Thank you for your help I followed what you told me to do, but it's not working for me. I must be a jinx! :) This may be a problem and I forgot to mention it in my previous posting. All the sheets have different amounts of data. Sheet1 has 4 values and Sheet2 has 9. So, what I did just to check it, I only copied the same amount of values from one sheet to the next and it didn't update my Data Label (Category Name) - Actually it has the same percentages and data labels. Not surw what I did wrong. Thanks again, Karen "Jon Peltier" wrote: The following technique is more reliable. Assuming Sheet1 is the sheet with data and a chart, copy Sheet1 and it will be named Sheet1 (2), then copy the data from Sheet2 and paste it into the same cells of Sheet1 (2). Sheet1 (2) will then contain a chart with the updated data that was pasted from Sheet2. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ .. "Karen" wrote in message ... Using Excel 2002 I created a pie chart on one sheet tab (Sheet1). I have 10 tabs of raw data. The data resides on their respective tabs. I want to use the same chart and format for each tab. I copied the chart from Sheet1 and pasted it to Sheet2. Then I right-clicked on the Sheet2 chart and changed the source data to refelct the data on sheet2. Is this a glitch or somethin? It doesn't update my data labels correctly. The percentages are wrong and it keeps the same category names from the Sheet1 chart. How can this be fixed so I don't have to recreate the chart each time? Thank you, Karen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change source data of a pivot chart | Charts and Charting in Excel | |||
Edit Chart to Change Source Data | Charts and Charting in Excel | |||
VBA to automatically change source data for existing chart | Charts and Charting in Excel | |||
Change source data in a pivot chart | Charts and Charting in Excel | |||
Can't change source data path for Pivot Chart | Charts and Charting in Excel |