Are you new to Jedox and want to learn how to create eye-catching charts for your reports? Combo charts in Jedox are a great way to present data that combines different types of information, and they are especially helpful when you want to visualize data in a simple and engaging way. In this beginner’s guide, we’ll walk you through the steps to create a combo chart in Jedox, and we’ll explore the types of reports where this chart can be particularly useful.
What is a Combo Chart?
A combo chart in Jedox combines two different types of charts in one visual representation. You can have one chart type, such as columns or bars, representing one set of data, and another chart type, like a line chart, representing a different set of data on the same graph. This combination allows you to compare data sets that might have different scales or units of measurement.
Creating a Combo Chart in Jedox
- Prepare Your Data: Make sure you have the data you want to chart ready in your Jedox spreadsheet. Organize it in a way that makes sense for your analysis.
- Select Your Data: Highlight the data range you want to include in your combo chart. This should include both the data for the bars and the data for the line.
- Insert Chart: In the menu, go to “Insert” > “Chart.” Choose the “Column Chart” option.
- Choose Chart Types: In the chart creation dialog, specify which chart type you want for each data series. For example, you can select “Clustered Bar” for the bars and “Line” for the line. The line can be added by clicking with the right click on the grey bar and then “Change series chart type“. Then choose the line.
- Customize Your Chart: Customize your combo chart by adding titles, labels, and adjusting the formatting as needed to make it easy to understand.
- Save and Share: Once your combo chart looks the way you want it, save your Jedox spreadsheet and share it with others to communicate your insights effectively.
When to Use Combo Charts
Combo charts in Jedox are handy for various types of reports:
- Sales and Revenue Reports: Compare sales figures (bars) with a trend line showing revenue growth (line).
- Budget vs. Actual Reports: Display budgeted amounts (bars) alongside actual expenses (line) for easy comparison.
- Inventory Analysis: Visualize inventory levels (bars) along with a moving average line (line) to spot trends.
- Performance Dashboards: Create visual dashboards that combine different metrics for quick insights.
Combo charts in Jedox make it easier for beginners to present complex data effectively. Experiment with these charts to find the best way to visualize your information and tell a compelling story with your data.
Now that you’ve learned how to create a combo chart in Jedox, go ahead and explore this powerful feature to make your reports more engaging and informative. Happy charting!
And of course, you can download the example here.