New line chart customization choices in Amazon QuickSight


Amazon QuickSight is a serverless, cloud-based enterprise intelligence (BI) service that brings knowledge insights to your groups and end-users via machine studying (ML)-powered dashboards and knowledge visualizations that may be accessed by way of QuickSight or embedded in apps and portals that your customers entry.

Line charts in QuickSight have undergone a serious overhaul this 12 months, beginning with an elevated restrict on the variety of knowledge factors that may be rendered in a single chart from 2,500 to 10,000 factors, adopted by lacking knowledge therapy, and at last ending this 12 months with line and marker customization choices.

With the brand new styling choices, you may make line charts extra readable and drive readers’ consideration in direction of the road collection you need to emphasize. Though colours assist convey that means, in sure instances selecting completely different line patterns may assist differentiate between strains for folks with shade blindness, and making strains daring may make them stand out from the remaining. Some enhancements like step line interpolation are greater than a styling characteristic, the place you’ll be able to show step strains for knowledge that modifications at a particular cut-off date and at irregular intervals. For instance, for those who have been to construct a chart of postage stamp costs within the US, a step line could be most popular than a slope to point change in value. The road between the dates would stay flat till the subsequent value change is noticed.

On this submit, we talk about the updates to the road chart customization choices and their advantages.

Line chart format pane updates

The info collection part beneath the format pane has been up to date with a brand new flyout menu consisting of line styling, marker customization, and axis settings. Authors can select to set a base model, which is a typical model throughout all collection, and in addition customise particular person collection by both selecting Choose Sequence to Fashion or by instantly choosing the collection on the road chart on the sheet. Beforehand, the lengthy listing of collection names made it tough to trace collection the place the axis setting was modified. This has been up to date to solely show individually styled collection. Additionally, you’ll be able to take away and reset to default styling for those who want to return to the earlier model.

The next determine compares the previous and new expertise.

Line styling

The info collection tab, the place customers alter axis placement (left and proper Y axis), now additionally consists of choices to model particular person collection or all collection within the line chart and alter presentation choices. For instance, you’ll be able to create a dot plot chart in QuickSight by hiding the road collection and displaying solely markers.

Let’s take a look at the lately added line styling choices:

  1. Line interpolation – Permit authors to decide on between linear, clean, and stepped line interpolation choices:
    1. Linear – Probably the most generally used line interpolation for pattern evaluation.
    2. Easy – A variation of line charts, which connects the info factors utilizing clean curves as an alternative of straight strains. Aside from the aesthetic facet, these charts are most popular for displaying a gradual change in traits and the place knowledge accuracy isn’t crucial.
    3. Stepped – A specialised model of the standard line charts, the place the info factors are related by way of step-like progressions as an alternative of straight strains. You should utilize stepped strains to view sudden and actual time of modifications within the knowledge, the place the vertical strains symbolize the magnitude of the modifications and the horizontal strains symbolize intervals of time the place knowledge is fixed. You can even use this method to create bump charts, that are generally used to visualise modifications in rank over time.

  2. Line model – One other solution to make your line charts extra accessible and printer pleasant is to outline line types to distinguish between collection. A basic instance could be visualizing precise and goal values throughout a given time interval. You’ll be able to select between stable, dotted, and sprint line model.
  3. Shade customization – Colours play an necessary function in conveying that means and driving person consideration. Though defining a definite shade for every collection helps distinguish between the completely different collection, doing the identical for numerous collection may add visible litter. As a part of finest practices in such instances, highlighting sure collection makes it simpler for readers to give attention to the necessary data, particularly whereas viewing numerous line collection.
  4. Line width – You’ll be able to select from predefined line widths to simply differentiate between line collection and let necessary values stick out to drive reader focus. Within the following instance, we’re fascinated with exhibiting the seasonality traits for gardening and residential decor in relation to different elements of the enterprise. To do this, as an alternative of assigning every collection a unique shade, we’d solely alter shade and improve thickness for gardening and residential decor and preserve different collection as gray and skinny. This manner, reader consideration is definitely drawn in direction of the thicker, coloured strains.

Marker customization

Information markers assist draw consideration to the info factors alongside a line. Additionally they turn out to be useful when exhibiting which knowledge factors are lined by your knowledge in case your line chart accommodates lacking knowledge factors. Information markers might be enabled for all collection or particular person collection. When enabling knowledge markers for all collection, try to be considered to keep away from visible litter and draw consideration to too many components.

These new customizations allow new use instances equivalent to dot plot charts (disguise line collection and show solely markers) and slope graphs. Information level markers will solely present up for knowledge factors the place knowledge exists and never for interpolated values utilizing the lacking knowledge management. The next are the marker properties:

  1. Form – Select from a predefined listing of marker shapes like circle, diamond, or sq..
  2. Dimension – Outline a dimension for the marker. Notice that the marker dimension needs to be higher than the road width to be seen.
  3. Shade – By default, markers are assigned the identical shade as particular person collection. Nevertheless, this may be modified as desired.

How one can model strains and markers

Create or select a line chart that you just need to model and select the pencil icon to open the Format visible pane. Navigate to the info collection part and choose the bottom model to use widespread styling choices to all collection—shade toned right down to mild gray and line interpolation as clean.


On this submit, we seemed on the new line and marker styling choices for line charts and how one can apply a typical model throughout all collection in addition to model every collection individually. We additionally seemed on the completely different ingress and Y axis placement choices. Be taught extra on methods to use small multiples in QuickSight To study extra, click on right here

We sit up for studying extra about your attention-grabbing use instances and suggestions on how we are able to higher serve you! Comply with the QuickSight Group to remain updated with new characteristic announcement, occasions, studying middle, and questions and solutions.

In regards to the writer

Bhupinder Chadha is a senior product supervisor for Amazon QuickSight centered on visualization and entrance finish experiences. He’s captivated with BI, knowledge visualization and low-code/no-code experiences. Previous to QuickSight he was the lead product supervisor for Inforiver, chargeable for constructing a enterprise BI product from floor up. Bhupinder began his profession in presales, adopted by a small gig in consulting after which PM for xViz, an add on visualization product.


Please enter your comment!
Please enter your name here