How to Use WPS Column Chart on Windows

Use WPS Column Chart on Windows through 4 how-to topics, all available without membership; start from the How-to Index to create, edit, configure data, and adjust chart style.

How-to Index

How-to Guide

1. Create a Column Chart

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

1. Open the dashboard interface and click "+ Add Component" in the upper-left area.
2. In the component panel, find "Column Chart" under the Chart category.
3. Click the Column Chart icon to generate a default chart component.
4. Select the new component to enter editing 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 editing panel to continue configuring data and style.

Tips While Using

• Common mistake: If you are not in the dashboard page, the Add Component entry may not be available.
• Environment note: Dashboard editing permission is required.

2. Edit or Export a Chart

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

1. Select the added column chart component.
2. Click the "..." icon in the upper-right area to open the drop-down menu.
3. Choose Configure, Copy, Copy as Image, Export as Image, or Delete as needed.
4. Follow the on-screen prompts to complete the selected action.

Success Criteria

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

Tips While Using

• Common mistake: If the chart is not selected first, the related menu may not open as expected.
• Environment note: Export and copy results depend on the current system clipboard and save location.

3. Configure Type and Data

Entry path: Column Chart editing panel → "Type and Data" tab

1. Open the column chart editing panel and switch to the "Type and Data" tab.
2. Select a data source and set filter conditions in the data range if needed.
3. Choose a dimension field for the horizontal axis and set the chart type to regular or stacked.
4. Set the statistic value, grouping, sort basis, sort order, and empty-cell display method.
5. Hide or show detail fields as needed.
6. Check the preview pane on the left, then click "OK" to apply the settings.

Success Criteria

• Interface result: The preview pane updates the column chart based on the current settings.
• Next action available: You can continue with style adjustments or return to the dashboard to review the result.

Tips While Using

• Common mistake: If the dimension field is not selected appropriately, the horizontal-axis categories may not match your expectation.
• Environment note: The data table needs fields that can be used for statistics and grouping.

4. Adjust Chart Style

Entry path: Column Chart editing panel → "Chart Style" tab

1. Open the column chart editing panel and switch to the "Chart Style" tab.
2. Choose a preset color scheme in Theme Color.
3. Set colors for different data series in Series Color.
4. Adjust chart elements such as text style, legend, and data labels.
5. Review the preview pane on the left, then click "OK" to apply the settings.

Success Criteria

• Interface result: The chart colors and element display update based on your settings.
• Next action available: You can return to the dashboard to review or export the chart.

Tips While Using

• Common mistake: If you change series colors but do not click "OK," the changes will not be applied.
• Environment note: Style results vary with the number of data series in the current chart.