Zoho Sheet supports the following data ranges:

1. Static: Allows you to specify any range of cells. Example: Sheet1.A1:C10
   
2. Named range: Allows you to add any named ranges in your sheet. Example: SalesData
   
3. Named Expression: Allows you to add a named expression. A named expression is a saved formula with a user-defined label. Example: Matric1 or Matric2
   

          

1. Formulas: Allows you to add formulas directly. Example: SORT(FILTER(D3:E62;C3:C62=I2);2;-1)

          

1. Table: Allows you to reference any tables in your sheet using the table name. Example: SalesTable
   
2. Basic array: Allows you to add arrays. Simply a set of values arranged in a single or multiple rows and columns. Example: {val1; val2; val3,...valn}
   

How to aggregate values in a chart

1. Operation: Allows  you to select the type of aggregation—sum, average, count, max, min, etc.
   
2. Values: Allows you to select the column on which aggregation should be performed.
   
3. Axis: This is the first level of grouping and allows you to select the column for which you need to group unique values. The unique values are displayed along the axis.
   
4. Legend: This is the second level of grouping and allows you to select the column for which you need to group unique values. The unique values will appear in the legend. 
   

How to filter values in a chart

1. Top/Bottom: Allows you to select Top or Bottom, based on how you want the values to be filtered.
   
2. N: Allows you to select the count of values need to be filtered.
   
3. Selection: Allows you to select the series for which you want to apply this filter. 
   

How to edit a chart 

1. Right-click on the preferred chart you wish to edit.
   
2. From the chart side pane that opens, you can select the desired tab in which you wish to make the changes.
   

1. Go to View > Navigation
   
2. From the side pane, you can click on the preferred chart to locate it inside the spreadsheet. You can also hide/unhide or delete the chart from the side pane. 
   

How to move a chart 

1. Right-click on the preferred chart and click Move.
   
2. From the list of sheets shown, you can select the sheet to which you want the chart to be moved.
   

How to delete a chart 

How to publish a chart 

1. Right-click on the preferred chart and click Publish.
   
2. From the Published Chart URL dialog, you can copy the link and share it with others. You can also embed the charts in webpages or documents by copying the embedded code. You can always revert publish by clicking the Remove Public option.  
   

How to save the chart as an image 

Right-click on the preferred chart and select Save as Image to download any specific chart.

Click here to know how to design your charts
Click here to know how to format your charts