Hi All - I have a report which has number values in y-axis and date in x-axis. This is a clustered column chart, the problem is for a particular date if one of my value is very huge say (in Thousands, Ex: 10000) and another is small (Ex: 120). In this case my small value bar is hardly visible. Hence in this case, I was looking around for an option like below, the y-axis interval needs to change dynamically based on value (i.e) until a threshold value the interval should be fixed say incremented by 120, once it reaches a threshold (Ex: 360) it should be auto (i.e) if the max value for that date is 3800 after 360 the interval needs to be in thousands or more based on the need. So based on the above explanation i would want the values like below for my y-axis - 120, 240, 360, 2000, 4000.
Please let me know in if this is possible. Hi smurug, Based on my understanding, you are creating a 3-D Clustered column. And you want to make the Y-axis values distribute uniformly, right? In Reporting Services, there is a scale break feature which can display two distinct ranges in the same chart area, then to make Y-axis values distribute uniformly. However, this feature is not supported in 3-D Clustered columns.
For more information, please refer to this article:. In your scenario, if you want to make Y-axis values distribute uniformly, you can add a secondary vertical axis to display those too larger values. Please refer to steps below: 1.
Go to Series Properties, enable secondary vertical axis, then design the report like below: 2. Preview the report. Reference: If you have any question, please feel free to ask. Best regards, Qiuyun Yu Qiuyun Yu TechNet Community Support. Hi smurug, Based on my understanding, you are creating a 3-D Clustered column. And you want to make the Y-axis values distribute uniformly, right?
Jun 11, 2018 - When creating a chart, you may want to adjust the default scaling that Excel applies to an axis. This is relatively easy to do by following the.
In Reporting Services, there is a scale break feature which can display two distinct ranges in the same chart area, then to make Y-axis values distribute uniformly. However, this feature is not supported in 3-D Clustered columns. For more information, please refer to this article:. In your scenario, if you want to make Y-axis values distribute uniformly, you can add a secondary vertical axis to display those too larger values. Please refer to steps below: 1. Go to Series Properties, enable secondary vertical axis, then design the report like below: 2.
Preview the report. Reference: If you have any question, please feel free to ask. Best regards, Qiuyun Yu Qiuyun Yu TechNet Community Support.
Microsoft Excel Training Improve your Microsoft® Excel® skills and learn how to produce insightful business reports. Discovering Excel: If you have basic Excel knowledge you would benefit from attending this intermediate Excel course. Excel on Steroids: If you use Excel extensively for business reporting, then this course is for you. The course is divided into three workshops covering specific topics in Excel. Excel on Steroids Plus: Data analysis, visualisation and dashboards will teach you how to model your data, create interactive dashboard reports, and make analysing your data much easier, giving you clearer insights into your company.
![For For](https://library.barnard.edu/sites/default/files/images/inline/slide51.jpeg)
Microsoft Excel Training Improve your Microsoft® Excel® skills and learn how to produce insightful business reports. Discovering Excel: If you have basic Excel knowledge you would benefit from attending this intermediate Excel course. Excel on Steroids: If you use Excel extensively for business reporting, then this course is for you. The course is divided into three workshops covering specific topics in Excel. Excel on Steroids Plus: Data analysis, visualisation and dashboards will teach you how to model your data, create interactive dashboard reports, and make analysing your data much easier, giving you clearer insights into your company. If you have plotted a graph and want to change the scale of the vertical axis to suit your needs, MS Excel allows you to customize the vertical axis.
By default, Microsoft Office Excel determines the minimum and maximum scale values of the vertical (value) in a chart. You can, however, customize the scale to better meet your needs. When the values that are plotted in the chart cover a very large range, you can also change the vertical (value) axis to a logarithmic scale (also known as log scale). Applies To: MS Excel 2003, 2007 and 2010. Assuming that you have just plotted the graph below 2. To change the scale of the vertical axis to: a. Minimum value = 5000 b.
Maximum value = 55 000 c. Major Unit = 5000 3. Right click on the vertical axis 4. Select format axis 5. Enter as per screen shot below 6. Select close 7. The following chart will be displayed with customised vertical axis values If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email and yours could be the next Tip of the Week.
Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations.