How to Use WPS Column Chart on macOS

Use WPS Column Chart on macOS with 4 how-to topics, all available without membership; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Create a Column Chart

Entry: Dashboard interface → "+ Add Component" → Chart → "Column Chart"

1. Open the dashboard interface.
2. Click "+ Add Component" in the upper-left area.
3. In the component panel, find "Column Chart" under the "Chart" category.
4. Click the icon to generate a default column chart component.
5. Select the new chart to enter edit mode and continue with data setup.

Success Criteria

• Interface result: A new column chart component appears in the dashboard.
• Next action available: You can open the edit panel and continue configuring data and style.

Tips While Using

• Common mistake: If the dashboard is not in an editable state, the add-component entry may not be available.
• Environment note: You need permission to edit the current dashboard.

2. Edit or Export a Chart

Entry: Select an existing chart → click the "..." icon in the upper-right area

1. Select the column chart that has already been added to the dashboard.
2. Click the "..." icon in the upper-right area.
3. Choose "Configure", "Copy", "Copy as Image", "Export as Image", or "Delete" as needed.
4. Complete the action for your current task.

Success Criteria

• Interface result: The menu opens and shows the available actions.
• Next action available: You can reconfigure, duplicate, export, or remove the chart.

Tips While Using

• Common mistake: If the chart is not selected first, the action menu may be easy to miss.
• Environment note: Wait until the chart finishes rendering before copying or exporting it as an image.

3. Configure Type and Data

Entry: Column chart edit panel → "Type and Data" tab

1. Open the column chart edit panel.
2. Switch to the "Type and Data" tab.
3. Select the data table in "Data Source".
4. Set the "Data Range" as needed and adjust conditions through "Data Filter".
5. Choose the field for "Dimension (Horizontal Axis)" and set the chart "Type" to regular or stacked.
6. In "Statistic Value (Vertical Axis)", choose "Count Records" or "Count a Specific Field".
7. Set "Group (Legend)", "Sort By", "Sort Order", "Display Empty Cells As", and "Fields Shown in Detail Data" as needed.
8. Review the preview on the left and click "OK" to apply the settings.

Success Criteria

• Interface result: The preview updates as the settings change.
• Next action available: After you click OK, the dashboard chart displays the new configuration.

Tips While Using

• Common mistake: If the horizontal-axis field and summary value do not match the data structure, the result may not match your expectation.
• Environment note: The data table needs fields that can be used for categorization, counting, and grouping.

4. Adjust Chart Style

Entry: Column chart edit panel → "Chart Style" tab

1. Open the column chart edit panel.
2. Switch to the "Chart Style" tab.
3. Choose a preset scheme in "Theme Color".
4. Expand "Series Color" to customize colors for each data series.
5. Expand "Chart Elements" to adjust text style, legend, and data labels.
6. Review the style effect in the preview area.
7. Click "OK" to save the style settings.

Success Criteria

• Interface result: Chart colors, legends, or label styles update based on your settings.
• Next action available: You can continue exporting the chart or return to the dashboard view.

Tips While Using

• Common mistake: If you only change the preview and do not click OK, the style changes are not applied.
• Environment note: The number of data series affects how series colors appear.