-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Medium
-
Component/s: Macros - Other - Native (1st Party)
-
None
-
1
-
Severity 3 - Minor
Issue Summary
When creating a chart from a table, columns with similar names (i.e., columns that start with the same words) are incorrectly merged in the chart. The chart truncates the column names and groups these columns together, resulting in a loss of distinct data representation.
Steps to Reproduce
- Create a table with multiple columns that have similar names
eg:
| Type | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Customer Ma+La | 4.5% | 7.2% | 5.9% | 2.1% | 0.0% | |||||||
| Internal Ma+La | 60.2% | 47.0% | 56.1% | 73.2% | 68.7% | |||||||
| Customer Ca+Ha | 4.9% | 3.6% | 4.1% | 3.2% | 1.3% | |||||||
| Internal Ca+Ha | 30.5% | 42.2% | 33.8% | 21.5% | 30.0% |
2. Click Insert chart.
Expected Results
The chart should display the same number of columns as in the original table, with each column shown separately and all information accurately represented.
Actual Results
The chart combines columns with similar names, truncates the names, and displays them as a single grouped column, causing data to be merged incorrectly.
Workaround
Use the Chart from Table macro to generate the chart, which preserves all columns and displays the data correctly.
