Autoexpanding a Date Type Chart using Microsoft Excel

» Autoexpanding a Date Type Chart using Microsoft Excel

VERSIONS: All Microsoft Excel Versions

The tip submitted by Dan Nickelson, Fargo, ND

When making a Chart that contains info for a date range, you often have to fill in data you know, and go back and adjust your Chart to include the subsequent date range once data is available.

To avoid this particular issue, make the data your Chart references a link to 'real' data. In this reference data area, insert a formula such as =if(A1<>"",A1,NA()) so the cells referencing accumulated data are filled in, while cells referenced not yet accumulated data are filled with #N/A.

You also need to set the chart to time-scale by selecting Chart Options\Axes\Time Scale

By doing this, you can have the chart reference 'dates' and data that haven't yet arrived. Excel ignores the #N/A fields until their referenced cells contain data, expanding the chart on the fly to include the 'new' data.

Screenshot // Autoexpanding a Date Type Chart using Microsoft Excel

Rate this tip



1	2	3	4	5

RATING: 3.04
VIEWS: 27333

Email Tip

Print Tip

Add to My Tips

excel chart with double x-axis

Natalie wrote on December 31, 1969 19:00 EST

Hello.....can one of you very EXCEL experts help me with a chart that has three paramters to be measured? I have an x-axis, y-axis and second x-axis to display....in a chart. How do I get the third chart to dispay properly?

Sponsors:

Book Store:

VIEW ALL BOOKS

Recommended Books:

Related MS EXCEL TIPS:

Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.