Another approach is to add new data to the range not at the end, but somewhere within the range.
We simply added a couple of finial feet to the base of the cabinets. Pin It I love how they instantly give the cabinet a much more expensive look.
The first shortcut works fine if you simply need to "fine tune" the range used in a chart.
(This approach only works if the chart is on object on the same worksheet that contains the data on which the chart is based.) Follow these steps: That's it—Excel incorporates the new data right into the existing chart, slick as a whistle.
If you add new data to the end of the range (after 11/13), then Excel doesn't know you want those items added to the chart.
Instead, insert some blank rows somewhere within the data range; it doesn't matter where, as long as the record for 11/13 is below the added rows.
Some energy-efficient changes are one-time investments. Even if you only implement two or three of these changes you will be saving energy, money, and the environment too.