We from time to time must insert a chart within a web page, or use charts in other non-Office programs. Is there a approach to insert charts in Excel workbooks into other applications? In actual fact, it can be achieved by saving the worksheet as an HTML file. When saving as a internet page, Excel will automatically convert the chart to a GIF file. If you believe that is troublesome, you may also make use of the VBA editor that comes with Workplace to write a simple macro to complete this perform.

\tSteps

1. Create a chart for practice and start off Excel. how to recover partition table using testdisk is Book1. Very first, we enter the data in Sheet1. Note here that the fluctuations within the data should not be also large, in order that the produced chart will not be coordinated.

The

1. Select cells A1 to E5, and after that execute the menu command 'Insert Chart' to open the 'Chart Wizard' dialog box. Click the 'Finish' button inside the dialog box to create the chart.

The

3. Press the shortcut crucial Alt+F11 to open the Visual Fundamental editor. Pick the workbook exactly where the chart is located inside the 'Project' window, and after that execute the menu command 'Insert Module' to open the 'Module 1' window, enter the following 4 lines of code within the window,

SubSaveChartAsGIF()

Fname=ThisWorkbook.Path''ActiveChart.Name'.gif'

ActiveChart.ExportFileName:=Fname,FilterName:='GIF'

EndSub

The

four. Return towards http://www.google.com , save the workbook to a folder, choose the chart, and then press the shortcut crucial Alt+F8 to open the 'Macro' dialog box. Choose the 'SaveChartAsGIF' macro and click the 'Execute' button.

The

The GIF file generated immediately after running the macro will probably be named immediately after the name on the chart and saved for the folder exactly where the workbook is located. Open the folder to see the generated GIF file. Use any image browsing computer software. You are able to browse the file, and you may simply insert this GIF file in other applications.