Skip to content

Latest commit

 

History

History
39 lines (24 loc) · 1.76 KB

column-renaming.md

File metadata and controls

39 lines (24 loc) · 1.76 KB
title last_updated toc summary sidebar permalink
Rename columns and axes
2/25/2020
false
You can rename columns and axes on your tables and charts.
mydoc_sidebar
/:collection/:path.html

When you perform a search or view and edit an Answer, you can rename the axes on your chart or the columns on your table. To rename columns in an underlying worksheet, so that these names persist for any user searching on a worksheet, see [create and use worksheets]({{ site.baseurl }}/admin/worksheets/about-worksheets.html).

Rename a chart axis

You can always rename a chart axis for clarity, brevity, format, and so on.

In the example below, it makes sense to rename the axis created from grouping as Item Price & Item Cost to something shorter, like Item Price and Cost.

To rename an axis, follow these steps.

  1. While viewing your answer as a chart, click the dropdown menu icon ![]({{ site.baseurl }}/images/icon-caret-right-20px.png){: .inline} next to the axis label you want to rename.

  2. Click Rename.

    ![Rename axis]({{ site.baseurl }}/images/edit-axis-rename.png "Rename axis")

  3. Type the new name in the text box that appears, and either click out or hit Enter/Return on your keyboard.

Rename a table column

You can rename a table column, or a pivot table column, in a similar way.

To rename a column, follow these steps.

  1. While viewing your answer as a table, click the more options menu icon ![]({{ site.baseurl }}/images/icon-more-10px.png){: .inline} that appears when you hover over a column name.

  2. Click Rename.

    ![Rename table column]({{ site.baseurl }}/images/chartconfig-renametable.png "Rename table column")

  3. Type the new name in the text box that appears, and either click out or hit Enter/Return on your keyboard.