Forum Discussion
How to setup Auto Display units in Line Chart which shows the Y axis Values correctly ?
Am trying to create a line chart. In that, I setup "Auto" Display units for Y axis and my data ranging from 0 to 300,000. So i expect Y- axis Grid line values should be 100K,200K,300K but am getting values 0.1M,0.2M, 0.3M . How to fix this? (I cant use custom Display units to Thousands or Millions as i have varying data ranges for different filter selection)
Hi agguru ,
Please try the following methods and check if they can solve your problem:
1.Create the simple table.
2.Select the line chart.
3.Drag the Date into the X-axis. Drag the Fiscal into the Y-axis and drag the name into the Legend.
4.In the Visualization pane, click on the Format pane. Expand the Y-axis section and set the display units to auto.
5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi agguru ,
Please try the following methods and check if they can solve your problem:
1.Create the simple table.
2.Select the line chart.
3.Drag the Date into the X-axis. Drag the Fiscal into the Y-axis and drag the name into the Legend.
4.In the Visualization pane, click on the Format pane. Expand the Y-axis section and set the display units to auto.
5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.