How to Customize the Data of X-Axis and Y-Axis in Chart Plus

It’s often difficult to present data the way you want it displayed when taking simple X-axis, Y-axis options to display a graph, as shown below:

Obviously, the muddled display above is not an effective way to present data. Data labels are overwritten and there is not enough information on the axis for the viewer to understand the content and the purpose of the chart. The question is, then: How do we customize the data label on the chart to display clearly? In this article, we’ll help you to do that easily.

Step 1: Customize in the X-Axis tab

These are default settings for Column, Line, Area, Bar (Y-Axis), and Combination chart types. There are four sections including Data Type Settings, Appearance, Category X-Axis Labels, and Sort. However, the Date Type Settings section will be hidden if the X (Category) Axis value is not a date/time field type.

  • Data Type Settings: Date Type only has Date and Time types, but we expanded Data Type formats. If users want to customize the date format, they would be able to do so by selecting Automatic, Years, Months, Weeks, or Days from the Date Scale dropdown. However, data will inherit the SharePoint date formatting if the Date Scale is “Automatic”.
  • Appearance: There are some options that should be selected by default, such as Display X-Axis Title, Display X-Axis Labels, Display Major Tickmarks, Display X-Axis Line. Toggle gridlines and tick marks displayed on the axes.
    • Display Major/Minor Gridlines: Gridlines extend from any horizontal and vertical axes across the plot area of the chart.
    • Display Major/Minor Tickmarks: Ticks are small lines between the axis and their labels. The interval of tick marks can be set by varying interval property of the parent axis.
    • Labels Angle: If users want to customize the data label, they would be able to do so by selecting Auto, Slant, and Rotate from the Label Angle dropdown. However, the numeric text box will be hidden if the Label Angel option is set to Auto or Slant.
  • Category X-Axis Labels: The user can customize values instead of using the category names from the data source.
  • Sort: If users want to sort the X-Axis label on the chart, they would be able to do so by selecting the Same as Data Source, Ascending, Descending from Sort Axis drop-down.

These are the default settings for Pie and Funnel chart types:

These are the default settings for Radar chart type:

These are the default settings for Scatter chart type:

These are the default settings for Polar chart type:

In this example, I have customized the X-Axis for the Column Chart:

Then I click the Preview hyperlink or Refresh button:

Step 2: Customize in the Y-Axis tab

These are the default settings for all chart types, except for Pie and Funnel. In the Chart Options tab, if users check”Secondary Axis” on a Y (Value) Axis series, that series should be plotted on a separate axis, independent from the Primary Y-Axis values and scale. So the Secondary Y-Axis Configuration uses the same default settings as the Primary Y-Axis Configuration.

Data Type Settings: Date Type has General, Number, Currency, Percentage, Scientific, Date, and Time types.

  • For Number types: We expanded Data Type formats for Number. The Decimal Places field should default to zero. Negative Numbers options should be “-1,234” and “1,234”. User 1000 Separator should be selected by default. The symbol field should contain the symbols.

  • For Date and Time types: It is the same logic as X-Axis but without the “Automatic” option.

  • Appearance: There are some options that should be selected by default, such as Display Y-Axis Title, Display Y-Axis Labels, Display Major Tickmarks, Display Y-Axis Line. However, the Display Major Gridlines option will be selected by default if you selected Radar and Polar chart types to plot the background chart. Toggle gridlines and tick marks displayed on the axes. And to make the data in a chart that displays axes easier to read, you can display a horizontal and vertical chart by using Labels Angle and Labels Position options.
    • Display Major/Minor Gridlines: Gridlines extend from any horizontal axes across the plot area of the chart.
    • Display Major/Minor Tickmarks: Ticks are small lines between the axis and their labels. The interval of tick marks can be set by varying interval property of the parent axis.
    • Labels Angle: If users want to customize the data label, they would be able to do so by selecting Auto, Slant, and Rotate from the Label Angle drop-down. However, the numeric text box will be hidden if the Label Angel option is set to Auto or Slant.
    • Labels Position: It only has Outside and Inside to display data on the chart.
    • Display Units: The drop-down should include Default, Hundreds, and Thousands, 10000, 100000, Millions, Billions.
    • Major Gridline Steps: The option only displays if the Display Major Gridlines option is selected.

These are the default settings for Pie and Funnel chart types. However, there is a difference in Labels Position. For Pie chart type, the Label Position drop-down has two options including Outside and Inside. For the Funnel chart type, the Label Position drop-down has three options such as Center, Left, and Right.

In this example, I’ve customized Y-Axis for the Column chart:

Then I click the Preview hyperlink or Refresh button:

And we have a completed chart in the main view. It’s very easy and looks great!

All SharePoint Versions

The web parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft® Office 365.

SharePoint 2013, 2016, 2019, Online (Office 365)

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2013, 2016, 2019

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials Suite


Essentials Plus Suite


Bamboo Premier Suite


Project Management Suite


Knowledge Management Suite


External User Manager


 

For more information on our product suites, contact us.

Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!