Exporting Data from an Enhanced Chart
Enhanced Charts allow you to export the data from a chart to a variety of formats. You can export the data to either picture or text/data format. If you choose to export the chart data to a picture format, such as EMF or JPG, you can choose the export size of the document, as well as the export location – the clipboard, a printer, or a file. If you choose to export the chart data to a text/data format, you can choose to export to the clipboard or a file.
When the data is exported, it can be used in a variety of ways and for multiple purposes, including further statistical analysis in Excel or for PowerPoint presentations.
If you export the chart data in a text/data format, the first row or column of the exported data represents the X axis and the second row or column represents the Y axis. Whether the axes are displayed in a row or column depends on the Export Style you select on the Export dialog box.
NOTE: Data exported from a Line/Multiline chart is interpolated. This is because the data is interpreted by assuming that the line between two values is a straight line. All points along that line are estimated. The data shown on the chart is processed and not the raw representation. However, if your Line/Multiline chart uses Trend for its historical mode, the chart's raw values are exported instead of the interpolated data.
