When creating or editing a chart, you have the option to manage each data series. You can assign a series a name, description, and color.
You also have the ability to:
- Decide whether you want the series to be displayed as a line graph or a bar graph.
- If you choose a line graph, control whether or not data markers should be displayed.
- Determine which vertical axis you want the series to follow.
Line vs. Bar Charts
Each data series on a chart can be displayed as either a line or a bar. A chart can be either all lines, all bars, or a mix of the two - you have total freedom.
To decide between a line and a bar, navigate to the Edit Chart window, and click next to the data series you want to edit, or click to make a new series.
In the resulting window select either “Line” or “Bar” in the “Type” field.
Pro tip: If you want to have your data series organized by category rather than date, click next to the “Date” field on the Edit Chart window; in the resulting window, select “Category.” (You can even make your categories Months if you don’t want a specific date). When working with categories, you can drag each row into its appropriate place.
If you're working with a line series, you'll be able to pick whether or not to show the markers. Markers are dots that mark each data point on the chart.
Hovering over the marker lets you see the exact value of that data point.
Pick the vertical axis
Each data series can follow either the left or right vertical axis. The two axes are scaled differently - meaning that the left axis might go from 0-5,000 to show the actual data count, while the right axis goes from 0-100 to show percentages.
This is useful if, for example, you want to create a Pareto chart - a bar chart with a cumulative percentage line. The bar(s) can be assigned to one axis and the line assigned to the other.