how to make a quick graph in excel for mac

Make A Quick Graph In Excel Free Trial Now

Super Filter (save and apply filter schemes to other sheets); Advanced Sort by monthweekday, frequency and more; Special Filter by bold, italic.

But you need to change or edit the number of the data every day, in this case, you have to update the chart manually so it includes the new data.

Are there any quick tricks to help you auto update a chart when you add new data to an existing chart range in Excel Auto update a chart after entering new data with creating a table Auto update a chart after entering new data with dynamic formula Auto update a chart after entering new data with creating a table If you have the following range of data and column chart, now you want the chart update automatically when you enter new information.

In Excel 2007, 2010 or 2013, you can create a table to expand the data range, and the chart will update automatically.

Select the data range and click Table under Insert tab, see screenshot: 2.

In the Create Table dialog box, if your data has headers, please check My table has headers option, then click OK.

See screenshot: 3.

And the data range is formatted as a table, see screenshot: 4.

Now, when you add values for June, and the chart will be updated automatically.

Your new entering data must be adjacent to the above data, it means there is no blank rows or columns between the new data and the existing data.

In the table, you are able to insert data between the existing values.

Auto update a chart after entering new data with dynamic formula But sometimes, you dont want to change the range to table, and the above method is not available in Excel 2003 or earlier version.

First, you need to create a defined name and a dynamic formula for each column.

Click Formulas Define Name.

In the New Name dialog box, enter Date into the Name box, and choose current worksheet name from Scope drop down list, and then enter OFFSET(A2,0,0,COUNTA(A:A)-1) formula into the Refers to box, see screenshot: 3.

In the Select Data Source dialog box, from Legend Entries(Series) section, click Ruby and then click the Edit button, in the popped out Edit Series dialog, enter Sheet3Ruby under Series values section, see screenshots: 6.

And then click OK to return to the Select Data Source dialog, repeat the step 5 to update the remaining series to reflect their dynamic ranges: James: Series values: Sheet3James; Freda: Series values: Sheet3Freda 7.

After setting the left data, now you need to click Edit button under Horizontal (Category) Axis Labels to set this option, see screenshots: 8.

Then click OK OK to close the Select Data Source dialog, after finishing these steps, youll find that the chart updates automatically when you add new data to the worksheet.

If you enter new column data, this method will not take effect.

Tip. If you want to quickly export range contents from sheet to a graphic, please try to use the Kutools for Excels Export Range as Graphic as shown in the following screenshot.

Make A Quick Graph In Excel Free Trial Now

Its full function without limitation in module 745 days, please download and have a free trial now.

Export graphics (PicturesChartsShapesAll Types) from workbook to a folder as GifTifPNGJPEG If there are multiple type of graphics in a workbook, and you just want to export all charts across worksheet to a folder as gif of other type of picture, you can use Kutools for Excels Export Graphics utilty, which only need 3 steps to handle this job.

Click for full-featured 30 days free trial Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

Related articles: How to add a horizontal average line to chart in Excel How to create combination charts and add secondary axis for it in Excel The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80 Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails.

Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range.

Merge CellsRowsColumns without losing Data; Split Cells Content; Combine Duplicate RowsColumns.

Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select.

Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more.

Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments.

How To Make A Quick Graph In Excel For Mac