How do you create a dynamic graph in Excel?

Answer by  worker8513 (14)

The simplest way to create a graph in Excel is to select the rows & columns containing the labels and data and click on the graph icon. This will bring up a dialog that will allow you to choose the graph type, labels, etc. Changing the data in the associated cells will automatically update the graph.

Answer by  roberta (45)

To create a dynamic graph, simply create the table where all the data will be, highlight that table, and then go to insert>graph. Then, using the graph wizard, choose your type of graph and click finish. If you change things on the table, the graph will change accordingly.

Answer by  kitty27 (6)

Prepare a chart for the dynamic graph to be loaded.Enter the graph name in the cell.Apply the data filter to the cell.Select a filter option and the graph is seen.

Answer by  nk409 (33)

Use formulas to draw over a range of series. If you want to draw in sheet1, For column A, B write formulas as =OFFSET(Sheet1!$a$1,1,0,counta($a:$a)-1), offset(sheet1!$b$1,1,0,counta($b:$b)-1).Give names for these two formulas and use formula bar/dialog box.Select the required graph and edit the series formula with your newly defined formula names

Answer by  gigo (1706)

Just mark the rows you want to visualize. You are just allowed to mark two rows for x and y. Then right click and select display as graph. Then choose x-y-diagram.