How to Use WPS Column Chart on Windows

Use WPS Column Chart with 4 how-to topics, including 4 free topics and 0 membership-related topics; use the index below to jump to the task you need.

How-to Index

How-to Guide

1. Create a Column Chart

Entry point: Dashboard page → "+ Add Component" → Chart → "Column Chart"

1. Open the dashboard page.
2. Click the "+ Add Component" button in the upper-left corner.
3. In the component panel, find "Column Chart" under the "Chart" category.
4. Click "Column Chart" to generate a default chart component automatically.
5. Click the component to enter edit mode and continue configuring the data.

Success Criteria

• UI state: A new default column chart component appears in the dashboard.
• Next actions: You can open the edit panel and continue setting data and styles.

Tips While Using

• Common mistakes: If you are not on a dashboard page, you may not see the Add Component entry.
• Environment limits: You need edit permission for the target dashboard.

2. Edit or Export a Chart

Entry point: Click an added chart → the "..." icon in the upper-right corner

1. Click the added column chart component.
2. Click the "..." icon in the upper-right corner to open the menu.
3. Choose the action you need: Configure, Copy, Copy as Image, Export as Image, or Delete.
4. Follow the on-screen prompts to complete the action.

Success Criteria

• UI state: The drop-down menu opens and shows the available actions.
• Next actions: You can copy, export, or reconfigure the chart.

Tips While Using

• Common mistakes: If the chart is not selected first, the menu may not show the related actions.
• Environment limits: Before exporting or deleting, confirm that the current chart has been saved as needed.

3. Set Type and Data

Entry point: Column Chart edit panel → "Type and Data" tab

1. Open the edit panel for the column chart.
2. Go to the "Type and Data" tab.
3. Select a data source.
4. Set the data range, dimension, type, statistic value, and grouping as needed.
5. Continue with sort basis, sort order, empty-cell display, and detail field display settings.
6. Review the result in the preview pane on the left, then click "OK" to apply it.

Success Criteria

• UI state: The preview area updates as the settings change.
• Next actions: After you click "OK," the chart displays with the new settings.

Tips While Using

• Common mistakes: If the dimension or statistic value is not selected appropriately, the chart result may not match your expectation.
• Environment limits: The data source must be accessible, and filter changes affect the chart result.

4. Set Chart Style

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

1. Open the column chart edit panel.
2. Go to the "Chart Style" tab.
3. Set the theme color.
4. Expand "Series Color" as needed and adjust the color for each data series.
5. In "Chart Elements," set text styles, legends, data labels, and related display items.
6. Preview the result and click "OK" to apply the settings.

Success Criteria

• UI state: The chart colors, labels, or legend styles change.
• Next actions: After the style update, you can continue exporting the chart as an image or return to the dashboard.

Tips While Using

• Common mistakes: If you change the style but do not click "OK," the result may not be applied.
• Environment limits: Style changes affect presentation only and do not change the original data.