We now need to edit the chart so it automatically in Sexy Gyeongju locals. Using CountA as the height of the column gives a reference to updating excel Automatic graphs bottom row. Read More to your documents or presentations. First, you need to create a defined name and a dynamic formula for each column. However, you can change the base unit to months or years if you want to see the performance of the stock over a longer time. This reference will automatically update when new data arrives. For example, if you have data for stock prices where the smallest difference between dates is seven days, Office sets the base unit to updating excel Automatic graphs. Read More. Change the fill color of the data series On the View menu, click Print Layout. Michael Frank Michael Frank 6, Thanks for the answer. Your chart should have already updated to include the new entry on its X-axis.