If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart not updating when Excel info is changed
I have Excel 2003
I have an excel spreadsheet that I copy over from month to month. It shows the dates that data was turned in from several different units each month. The problem is that although I enter the new date into the excel sheet, the date from the last month shows up on some of the units in the chart... but not on all units! that is what seems so odd. I checked to see the correct dates were entered and checked the source/series to see it was referring to the column with the dates I entered. but on 4 of the units (there are 11 units in total) the date is from the month before.... Any ideas? Thanks, Meenie |
#2
|
|||
|
|||
Chart not updating when Excel info is changed
If you wish, send me a sample file - get my email from my website
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Meenie" wrote in message ... I have Excel 2003 I have an excel spreadsheet that I copy over from month to month. It shows the dates that data was turned in from several different units each month. The problem is that although I enter the new date into the excel sheet, the date from the last month shows up on some of the units in the chart... but not on all units! that is what seems so odd. I checked to see the correct dates were entered and checked the source/series to see it was referring to the column with the dates I entered. but on 4 of the units (there are 11 units in total) the date is from the month before.... Any ideas? Thanks, Meenie |
#3
|
|||
|
|||
Chart not updating when Excel info is changed
I'm sorry I never answered you, Bernard, but I found the answer. the numbers
had become unlinked and I didn't know that a little box would show up in the Data Labels tab that said "link" if it wasn't linked, but it doesn't show up if it is linked. "Bernard Liengme" wrote: If you wish, send me a sample file - get my email from my website best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Meenie" wrote in message ... I have Excel 2003 I have an excel spreadsheet that I copy over from month to month. It shows the dates that data was turned in from several different units each month. The problem is that although I enter the new date into the excel sheet, the date from the last month shows up on some of the units in the chart... but not on all units! that is what seems so odd. I checked to see the correct dates were entered and checked the source/series to see it was referring to the column with the dates I entered. but on 4 of the units (there are 11 units in total) the date is from the month before.... Any ideas? Thanks, Meenie |
Thread Tools | |
Display Modes | |
|
|