Visio uses Microsoft Excel 2010 to provide advanced charting capabilities. If Excel 2010 is not installed, Visio uses Microsoft Graph instead.
You can add a data chart or graph to your diagram in one of two ways:
- You can create a new chart or graph in your diagram. When you create a new chart in Visio, you edit the data for that chart in Excel, but the data is saved with the Visio file.
- On the Insert tab, in the Illustrations group, click Chart.
An embedded Excel workbook is added to the diagram. The workbook has two worksheets: a chart and a data sheet. To add your data, click the page tab labeled Sheet1 in the Excel workbook. The Visio Ribbon changes to contain Excel tabs so you can work with the data. To format the chart, select it in the embedded workbook. Three Chart Tools tabs appear on the Ribbon; use the commands and galleries on these tabs to format the chart.
- You can paste an Excel chart or graph into your diagram and link to the data in an Excel file. When you copy a chart from a saved Excel file and paste it into your diagram, the data in the chart is linked to that Excel file. If you want to change the data in the chart, you must make your changes to the linked worksheet in Excel, and then refresh the data in your Visio diagram. The Excel worksheet is a separate file and is not saved with the Visio file.
Top of Page