Friday, December 2, 2022
HomeBig DataNew line chart customization choices in Amazon QuickSight

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 through QuickSight or embedded in apps and portals that your customers entry.

Line charts in QuickSight have undergone a significant overhaul this yr, 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 remedy, and at last ending this yr with line and marker customization choices.

With the brand new styling choices, you can also make line charts extra readable and drive readers’ consideration in direction of the road sequence you need to emphasize. Though colours assist convey which means, in sure instances selecting totally different line patterns might assist differentiate between traces for folks with coloration blindness, and making traces daring might make them stand out from the remainder. Some enhancements like step line interpolation are greater than a styling characteristic, the place you possibly can show step traces for knowledge that adjustments at a selected time limit and at irregular intervals. For instance, in the event you had been to construct a chart of postage stamp costs within the US, a step line can be most well-liked than a slope to point change in worth. The road between the dates would stay flat till the subsequent worth change is noticed.

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

Line chart format pane updates

The information sequence 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 fashion, which is a typical fashion throughout all sequence, and likewise customise particular person sequence by both selecting Choose Collection to Type or by straight choosing the sequence on the road chart on the sheet. Beforehand, the lengthy listing of sequence names made it tough to trace sequence the place the axis setting was modified. This has been up to date to solely show individually styled sequence. Additionally, you possibly can take away and reset to default styling in the event you want to return to the earlier fashion.

The next determine compares the outdated and new expertise.

Line styling

The information sequence tab, the place customers alter axis placement (left and proper Y axis), now additionally consists of choices to fashion particular person sequence or all sequence within the line chart and alter presentation choices. For instance, you possibly can create a dot plot chart in QuickSight by hiding the road sequence and displaying solely markers.

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

  1. Line interpolation – Enable authors to decide on between linear, easy, and stepped line interpolation choices:
    1. Linear – Probably the most generally used line interpolation for development evaluation.
    2. Easy – A variation of line charts, which connects the info factors utilizing easy curves as a substitute of straight traces. Other than the aesthetic facet, these charts are most well-liked for displaying a gradual change in developments and the place knowledge accuracy isn’t vital.
    3. Stepped – A specialised model of the standard line charts, the place the info factors are linked through step-like progressions as a substitute of straight traces. You should use stepped traces to view sudden and actual time of adjustments within the knowledge, the place the vertical traces characterize the magnitude of the adjustments and the horizontal traces characterize durations of time the place knowledge is fixed. It’s also possible to use this strategy to create bump charts, that are generally used to visualise adjustments in rank over time.

  2. Line fashion – One other solution to make your line charts extra accessible and printer pleasant is to outline line types to distinguish between sequence. A basic instance can be visualizing precise and goal values throughout a given time interval. You’ll be able to select between strong, dotted, and sprint line fashion.
  3. Coloration customization – Colours play an necessary position in conveying which means and driving consumer consideration. Though defining a definite coloration for every sequence helps distinguish between the totally different sequence, doing the identical for numerous sequence might add visible litter. As a part of finest practices in such instances, highlighting sure sequence makes it simpler for readers to deal with the necessary data, particularly whereas viewing numerous line sequence.
  4. Line width – You’ll be able to select from predefined line widths to simply differentiate between line sequence and let necessary values stick out to drive reader focus. Within the following instance, we’re concerned about exhibiting the seasonality developments for gardening and residential decor in relation to different components of the enterprise. To do this, as a substitute of assigning every sequence a distinct coloration, we’d solely alter coloration and enhance thickness for gardening and residential decor and preserve different sequence as gray and skinny. This fashion, reader consideration is definitely drawn in direction of the thicker, coloured traces.

Marker customization

Knowledge markers assist draw consideration to the info factors alongside a line. In addition they turn out to be useful when exhibiting which knowledge factors are coated by your knowledge in case your line chart comprises lacking knowledge factors. Knowledge markers may be enabled for all sequence or particular person sequence. When enabling knowledge markers for all sequence, try to be considered to keep away from visible litter and draw consideration to too many components.

These new customizations allow new use instances corresponding to dot plot charts (cover line sequence and show solely markers) and slope graphs. Knowledge 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. Measurement – Outline a measurement for the marker. Be aware that the marker measurement needs to be higher than the road width to be seen.
  3. Coloration – By default, markers are assigned the identical coloration as particular person sequence. Nevertheless, this may be modified as desired.

How one can fashion traces and markers

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


On this put up, we appeared on the new line and marker styling choices for line charts and how one can apply a typical fashion throughout all sequence in addition to fashion every sequence individually. We additionally appeared on the totally different ingress and Y axis placement choices. Study extra on the way to use small multiples in QuickSight To be taught extra, click on right here

We stay up for studying extra about your fascinating use instances and suggestions on how we will higher serve you! Comply with the QuickSight Group to remain updated with new characteristic announcement, occasions, studying middle, and questions and solutions.

Concerning the writer

Bhupinder Chadha is a senior product supervisor for Amazon QuickSight targeted 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, answerable 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

Most Popular

Recent Comments