Creating charts using Zoho Writer

Working with Charts

Overview

Adding charts is quite common while creating business documents. Based on depending on your need you can:
  1. Add static charts.
  2. Add dynamic charts: Automatically updates when the data in the Sheet linked to it is updated.
  3. Convert a table to chart.
  4. Embed charts: Embed a chart created in a Zoho Sheet.

Steps

Insert a dynamic chart

  1. Open your Writer document or create a new document.
  2. Go to the Insert tab --> Chart.
  3. From the chart types show in the dropdown, select one. The chart will be inserted.
  4. The chart inserted will be linked to a new Zoho Sheet file. Select the chart and click the edit icon thta is displayed beside it to open the linked Sheet and update its data. This will automatically make changes to your chart inside Writer.

Insert a static chart

Create a chart in Zoho Sheet, add it to My Library, open your document in Writer, and insert this chart from My Library. This will add the chart as an image. Click here for detailed steps.

    Embed a chart created in Zoho Sheet

    Create a chart in Zoho Sheet, publish it, copy the embed code, and use it to embed the chart in your Writer document.

    IdeaClick here to know how to embed charts from Zoho Sheet to your Writer document.

    Convert a table to chart

    You can transform the table inserted in your document into charts. For example, if you are creating a business report and want to convert a table that has the yearly profits data into a graph, you can use the "Convert table to chart" option. You do not have enter the data in a Sheet or Excel file for converting the data. Instead, create a table in Writer and simply click “Convert table to chart” to make the conversion. Once the chart is created in your document, you can edit it anytime.

    To convert a table to chart,

    1. Select your table.
    2. Right click on your table, click More options > Convert table to chart.

    Once the table data is converted into a chart, the data can be edited in Zoho Sheet. See Edit chart data for more details.

    Edit and customize charts

    Once the chart is inserted in your document, you can edit and update the data linked to Zoho Sheet. Also, copy/paste charts as image files from MS Word and Google Docs.

    Edit Chart data

    To edit the chart,

    1. Click the Edit icon near your chart inserted in your document. This will open a new Zoho Sheet file.
    2. Make changes in your Sheet file. The changes will be automatically saved in your spreadsheet.
    3. Now click the Refresh icon near the chart. The chart data will be automatically updated with respect to the changes made in your Sheet.

    You can change the chart type or resize the chart, to suit your needs.

    Copy/Paste charts

    You can easily copy/paste charts within your Writer documents.

    While pasting the chart from Zoho sheet, you can link the source sheet to the chart directly. The chart data will be updated with respect to the changes made in your source sheet.

    To link the source sheet file,

    1. Copy/Paste chart from the Zoho Sheet file in your document.
    2. Click the icon near the pasted chart and choose the "Link to Source Sheet option". 

    The chart will be linked to the Sheet file. Any changes made to sheet data will be updated in the chart by clicking the Refresh icon in the inserted chart.

    You can also copy and paste Charts as image files from MS Word and Google Docs.