first
Here are some questions and answers from the forum regarding the issue where the Y-axis scale is not displaying properly in graphs created in Smartsheet reports.
Question
Some users are reporting an issue where the Y-axis scale is not displaying properly in charts created in Smartsheet reports. Even though I copied the same report and filtered for different processes, the Y-axis scale is not displayed correctly.
answer
According to a Smartsheet support representative, this issue may be due to the column order of the chart. When a Y-axis value is selected as a series label in a chart, the Y-axis scale is set based on the column order.
solution
To resolve this issue, you need to reorder the columns in the chart. Specifically, follow these steps:
- Select the chart with the problem.
- Click the Edit button at the top of the graph.
- Select the Data tab.
- In the Series section, select the column you want to use as the Y-axis values.
- Use the Up or Down buttons to change the column order.
- Click the Save button.
Summary
If the Y-axis scale is not displaying correctly in a Smartsheet chart, it may be due to the order of the columns in the chart. You can resolve the issue by changing the column order as per the above solutions.
Translation of correspondence
Hello,
In the graph, the y-axis does not show the proper scale. However, I just copied the same report and filtered for different processes. Please help me regarding this matter.
answer
jmyzk_cloudsmart_jp ✭✭✭✭✭✭
12/20/23
@kumars23
I tried reproducing your problem. His second graph in the image below has a similar problem. As you can see, the order of the columns in report ac is Y, X, Y-2, so the Y value is selected as the series label.
The first and third charts contain an X as the first column in the source report.
Therefore, the order of the columns in the report for the second chart may be different from the first chart.
