Note: On August 2, 2021, we will officially update charts in Aha! Roadmaps and Aha! Ideas Advanced to a new experience. The new experience includes improved aesthetics and more intuitive configuration controls.

Beginning on April 14, new charts created in your account will use the new design. You can switch back and forth between the styles until August 2, 2021, when the new experience will be permanently applied.

Aha! Roadmaps | Create a chart

If the right picture is worth a thousand words, the right chart is worth a hundred meetings. A chart can distill your ambitious goals into one image, show your strategic progress at a glance, or highlight a trend in your data that your audience might otherwise have missed.

But there is an art to chart configuration. Configured incorrectly, your chart might be too disorganized to be effective, with confusing labels, mismatched colors, and a format that does not tell the story you intend.

Aha! Roadmaps includes a wide variety of highly customizable charts so you can always find the right vehicle for your data's story. And since you use Aha! Roadmaps to track your strategic work already, your charts will automatically update as your data does. You can also convert existing list reports and pivot tables to charts — no need to reselect your fields and filters — and add charts to dashboards, notes, and Aha! presentations, where they can become an integral and beautiful part of your narrative.

In this article, we will preview each of the chart types you can create, list the different ways to customize each one, and detail how to save and share your chart with your audience.

Click any of the following links to skip ahead:

Create a chart

There are three ways to create a chart.

First, you can always start with an example chart. Aha! Roadmaps has over 75 prebuilt reports, roadmaps, and charts to choose from. Navigate to Roadmaps → Overview and select Example reports at the top left of the screen, select an example chart from the report builder, or click on Views → Related views from the chart page before you open the report builder to see a complete list of example reports.

Second, you can build a chart from scratch. Navigate to Roadmaps → Chart and click Create new chart.

Finally, you can convert list reports, pivot tables, and custom roadmaps to charts using the Change report type dropdown in the upper left of the report or roadmap's page. This starts your chart building process off with record types already selected, so you can build a report with the same record relationships that you used for your report or roadmap.

However you choose to build a chart, the report builder will walk you through the process.

In the Select records step, select the primary record you want to use to build your chart, then optionally link an additional record type from the suggestions (for example, you might want a chart built from both ideas and idea votes).

In the Add fields step, you can add more record types and their fields to your chart configuration. Remember, Aha! Roadmaps' reports are built on the relationships between record types, and the order you add related record types to your chart matters. As you work through the report builder, try experimenting with different record types, and see how it affects the chart you create. All data displayed in the chart will be in relation to the primary record selected.

In the Add fields step, select the chart type you wish to create. Click Save to create your chart.

Top

Column charts

There are three types of column charts available to you.

Column charts visualize your data in columns vertically along an X- and Y-axis. You can select how to calculate the height of the columns along the Y-axis, assign fields to the axes, and assign an optional series field.

Stacked column charts visualize your data in columns along an X- and Y-axis, and break down each column into parts determined by an optional Series. You can select how to calculate the height of the columns along the Y-axis, assign fields to the axes, and assign a series field.

100% stacked column charts visualize your data in columns along an X- and Y-axis, showing you a percentage breakdown of the columns' parts, determined by an optional Series. You can select how to calculate the height of the columns along the Y-axis, assign fields to the axes, and assign a series field.

When you customize a column chart, you have a few settings to choose from.

In the Chart section:

  • Adjust the default Title of your chart.

  • Select the Position of the bars, either Horizontal or Vertical.
    Note: This setting effectively converts column charts to bar charts and vice versa.

  • Select whether the bars should be Grouped (side by side) or Stacked (on top of each other). If you choose Stacked, you can also choose whether the bars should fill part of 100% of the chart.

  • Select where your chart's Legend should appear if you want to include one.

  • Enable or disable Data counts. If you enable Data counts, your chart will include labels for each data point in the chart.

In the Horizontal axis section:

  • Choose whether to enable the vertical (Y) axis.

  • Give the axis an optional Title.

  • Adjust the Slant of the axis Labels.

  • Add a Prefix or a Suffix to the axis Labels. Anything you add here will appear directly in front of or directly after each label. Click the Refresh icon to undo your changes.

  • Add boundaries to your data. For example, if you notice that your trendline is getting cut off at its apex, increase the Max of the vertical axis to make more room. Click the Refresh icon to undo your changes.

In the Vertical axis section:

  • Choose whether to enable the horizontal (X) axis.

  • Give the axis an optional Title.

  • Adjust the Slant of the axis Labels.

In the Series section:

  • Choose whether you want the series colors to sync with data color. If you have selected custom colors for a data element (custom status colors, for example, or a custom color for each initiative), the chart can use the same colors so that your data appears consistently everywhere.

  • For each data element in the series, you can also select a different custom color by clicking on the color button. Click the Refresh icon to undo your changes.

Top

Bar charts

There are three types of bar charts available to you.

Bar charts visualize your data in columns horizontally along an X- and Y-axis. You can select how to calculate the length of the columns along the X-axis, assign fields to the axes, and assign an optional series field.

Stacked bar charts visualize your data in columns along an X- and Y-axis and break down each column into parts determined by an optional Series. You can select how to calculate the length of the columns along the X-axis, assign fields to the axes, and assign a series field.

100% stacked bar charts visualize your data in columns along an X- and Y-axis, showing you a percentage breakdown of the columns' parts determined by an optional Series. You can select how to calculate the length of the columns along the X-axis, assign fields to the axes, and assign a series field.

When you customize a bar chart, you have a few settings to choose from.

In the Chart section:

  • Adjust the default Title of your chart.

  • Select the Position of the bars, either Horizontal or Vertical.
    Note: This setting effectively converts column charts to bar charts and vice versa.

  • Select whether the bars should be Grouped (side by side) or Stacked (on top of each other). If you choose Stacked, you can also choose whether the bars should fill part of 100% of the chart.

  • Select where your chart's Legend should appear if you want to include one.

  • Enable or disable Data counts. If you enable Data counts, your chart will include labels for each data point in the chart.

In the Horizontal axis section:

  • Choose whether to enable the horizontal (X) axis.

  • Give the axis an optional Title.

  • Adjust the Slant of the axis Labels.

In the Vertical axis section:

  • Choose whether to enable the vertical (Y) axis.

  • Give the axis an optional Title.

  • Adjust the Slant of the axis Labels.

  • Add a Prefix or a Suffix to the axis Labels. Anything you add here will appear directly in front of or directly after each label. Click the Refresh icon to undo your changes.

  • Add boundaries to your data. For example, if you notice that your trendline is getting cut off at its apex, increase the Max of the vertical axis to make more room. Click the Refresh icon to undo your changes.

In the Series section:

  • Choose whether you want the series colors to sync with data color. If you have selected custom colors for a data element (custom status colors, for example, or a custom color for each initiative), the chart can use the same colors so that your data appears consistently everywhere.

  • For each data element in the series, you can also select a different custom color by clicking on the color button. Click the Refresh icon to undo your changes.

Top

Line charts

There are two types of line charts available to you. In either line chart, when you hover over a data point, the chart will display a tooltip with your data's value at that point, and a vertical dotted line to the point you are referencing.

Line charts display data trends over time by plotting lines through a series of data points across an X- and Y-axis. You can select how to calculate the height of the data points along the Y-axis, assign fields to the axes, and assign an optional series field.

Smooth line charts display data trends over time by plotting lines through a series of data points across an X- and Y-axis but smooth the line(s) to give a better visual sense of the trend. You can select how to calculate the height of the data points along the Y-axis, assign fields to the axes, and assign an optional series field.

When you customize a line chart, you have a few settings to choose from.

In the Chart section:

  • Adjust the default Title of your chart.

  • Select whether the Trendline for your chart should be Linear or Smooth.

  • Select where your chart's Legend should appear if you want to include one.

  • Enable or disable Data counts. If you enable Data counts, your chart will include labels for each data point in the chart.

  • Choose whether or not your chart should Plot null values.

In the Horizontal axis section:

  • Choose whether to enable the horizontal (X) axis.

  • Give the axis an optional Title.

  • Adjust the Slant of the axis Labels.

In the Vertical axis section:

  • Choose whether to enable the vertical (Y) axis.

  • Give the axis an optional Title.

  • Adjust the Slant of the axis Labels.

  • Add a Prefix or a Suffix to the axis Labels. Anything you add here will appear directly in front of or directly after each label. Click the Refresh icon to undo your changes.

  • Add boundaries to your data. For example, if you notice that your trendline is getting cut off at its apex, increase the Max of the vertical axis to make more room. Click the Refresh icon to undo your changes.

In the Series section:

  • Choose whether you want the series colors to sync with data color. If you have selected custom colors for a data element (custom status colors, for example, or a custom color for each initiative), the chart can use the same colors so that your data appears consistently everywhere.

  • For each data element in the series, you can also select a different custom color by clicking on the color button. Click the Refresh icon to undo your changes.

Top

Pie charts

There are three types of pie charts available to you.

Pie charts divide your data into slices to show each slice's proportion relative to the whole. You can choose how to determine the size of the slices, and assign fields to the pie and to the slices.

Donut charts divide your data into slices to show each slice's proportion relative to the whole. They have a hole in the center to present a slightly different appearance than a pie chart. You can choose how to determine the size of the slices, and assign fields to the pie and to the slices.

3D pie charts divide your data into slices to show each slice's proportion relative to the whole and visualize the result in three dimensions. You can choose how to determine the size of the slices, and assign fields to the pie and to the slices.

Note: 3D pie charts will be deprecated with the charts design migration in August 2021.

When you customize a pie chart, you have a few settings to choose from.

In the Chart section:

  • Adjust the default Title of your chart.

  • Select whether the Type of pie chart should be a Pie or a Donut.

  • Select where your chart's Legend should appear if you want to include one.

  • Enable or disable Data counts. If you enable Data counts, your chart will include labels for each data point in the chart.

  • If you have enabled Data counts, select whether the pie chart's Slices should display the Values of the data or the Percentage of the pie.
    Note: Your selection here does not change the size of the slices, just the values they display.

  • Select whether the data's Labels should be Outside, Inside, or disabled altogether. If you select Inside, the Label text color will update automatically from black to white based on the color of the slices to preserve readability.
    Note: If you select Inside, then the Labels will replace your selection in the Slices setting.

In the Series section:

  • Choose whether you want the series colors to sync with data color. If you have selected custom colors for a data element (custom status colors, for example, or a custom color for each initiative), the chart can use the same colors so that your data appears consistently everywhere.

  • For each data element in the series, you can also select a different custom color by clicking on the color button. Click the Refresh icon to undo your changes.

Top

Other charts

There are two types of other charts available to you.

Scatter charts display a group of data points across an X- and Y-axis. You can assign fields to the X- and Y-axes, and assign a field to be the label that appears when you hover over a data point.

Bubble charts display a group of data points across an X- and Y-axis, with the ability to use a third dimension of data to affect the size of the bubbles. You can assign the field to be the label that appears when you hover over a bubble, assign fields to the X- and Y-axes, and assign an optional series field.

When you customize a scatter or bubble chart, you have a few settings to choose from.

In the Chart section:

  • Adjust the default Title of your chart.

  • Select the Bubble size, depending on whether you want a compact or expanded chart.

  • Select where your chart's Legend should appear if you want to include one.

  • Select whether to enable or disable Labels on your data.

In the Horizontal axis section:

  • Choose whether to enable the horizontal (X) axis.

  • Give the axis an optional Title.

  • Adjust the Slant of the axis Labels.

In the Vertical axis section:

  • Choose whether to enable the vertical (Y) axis.

  • Give the axis an optional Title.

  • Adjust the Slant of the axis Labels.

  • Add a Prefix or a Suffix to the axis Labels. Anything you add here will appear directly in front of or directly after each label. Click the Refresh icon to undo your changes.

  • Add boundaries to your data. For example, if you notice that your trendline is getting cut off at its apex, increase the Max of the vertical axis to make more room. Click the Refresh icon to undo your changes.

In the Series section:

  • Choose whether you want the series colors to sync with data color. If you have selected custom colors for a data element (custom status colors, for example, or a custom color for each initiative), the chart can use the same colors so that your data appears consistently everywhere.

  • For each data element in the series, you can also select a different custom color by clicking on the color button. Click the Refresh icon to undo your changes.

Top

Customize your chart

Once you have created your chart, there are three ways to customize it.

First, click Edit data to open the report builder and adjust the fields that you are using to create your chart.

Second, filter your chart. Hover over the filters bar and click the Add filters + icon to add basic filters quickly, or click the Edit filters icon to open the report builder to the Add filters step and add advanced filters.

Finally, use the Configure chart panel on the right side of your screen to customize your chart. Your customization options differ slightly depending on the chart you select, but you can see any changes you make reflected immediately in your chart.

Top

Save your chart

To save your current view, click the Save view button in the top right corner of the page. When you save a view, you will have the option to name it, choose who you wish to share your saved view with, and select if others can edit the view. The Views dropdown lets you access any view you have ever saved.

Top

Share your chart

With your chart completed, you can easily share it with your stakeholders by selecting one of the export options under the Share button on the top-right corner of the screen.

  • To fold your charts into a presentation, select Add to presentation. In your presentation, you can select the chart's update frequency.

  • To add your chart to a dashboard, select Add to dashboard. Dashboards combine several Aha! Roadmaps views into one page to tell a complete story about your plans and progress.

  • To invite people outside of your Aha! Roadmaps account to view your charts, select Share as webpage.

  • To export your chart for further analysis, export it to Microsoft Excel or CSV file. You can import from CSV to update data later.

  • For a static version of your chart, export your chart to PNG image or PDF document.

Top

Aha! Roadmaps
    Strategic roadmaps
      Account management
      Integrations
      Aha! Ideas
      Videos
      Announcements
      © 2021 Aha! Labs Inc.All rights reserved