Home / Tech Tip / Crystal Tech Tip / Crystal Reports – Creating a Combo (Control) Chart

Crystal Reports – Creating a Combo (Control) Chart

Question: How do you create a chart that has both a Bar chart and a Line chart together in one?

Example: (from MS Excel)

Answer:The easiest way to accomplish this in Crystal Reports is to start with a Bar chart. If you want to incorporate all of the data in your report, I suggest placing the chart in the Report Header or Report Footer. In this Tech Tip, I’ll assume you have the data you want in the report.

Steps: (using the Xtreme Sample Database)

  1. Click on the Insert Chart button and place the chart in the report.
  2. If you have at least one group and one summary for a group, the chart will be automatically built. Otherwise, you’ll be brought directly into the Chart Expert. Either way, open the Chart Expert and select the Data Tab.
  3. With the Advanced Layout selected, the On change of choice will most likely be what you want to group on and will be the x-axis. In this example we are using {Orders.Order Date}.
  4. In the Show values: section place the fields you are summarizing. In this example, we are using a Distinct Count of {Orders.Order ID} and a Sum of {Orders.Amount}.

  1. Next, make sure you have the Side by side bar chart selected on the Type tab. You can also start from a Line chart or Numeric Axis chart.

  1. Go ahead and select OK to close the Chart Expert.
  2. Now, you will want to Preview your chart and work entirely from the Preview tab. This allows Crystal to understand your data and make changes according to those values.
  3. Right-click on the chart and select Chart Options. Go to the Axes tab and select Dual Axes. Show Data2 Axes should also be automatically selected.

  1. If you have more than two colors showing, you will want to make sure that Color by Series is selected on the Legend tab before selecting OK to close Chart Options.
  2. In our example, we will leave the Count as a bar/ riser and change the Sum ($) as the line. Since the Sum is second in our Show value(s) list, let’s select the second bar and then right-click on it in order to select Series Options.

  1. Using the Appearance tab, select Line in the Show Selected Series As: dropdown box.

  1. Go ahead and select OK to close the Series Options.

Now you have your Combo chart. Of course, you will want to pretty it up with titles and formatting of the series. I’ll leave those options up to you. However, I am a big fan of the Auto-Arrange Chart option on the right-click/ context menu. 



About ckruger

Check Also

Let’s Speak BO Webinar: Design and Development Techniques for Mobilizing SAP Dashboards October 17, 2017

Webinar: Design and Development Techniques for Mobilizing SAP Dashboards

Join us in a fantastic and informative session with expert developer and Dashboards Consultant, Roxanne …

One comment

  1. Hi
    I do not have the option “Series Options” in my Crystal reports when clicking (Right Click) on the Chart in crystal reports.I installed CRforVS_13_0_4 but don’t see the “Series Options” function in my Visual studio in Crystal reports as shown in the sample from webaddress below.
    Crystal Reports – Creating a Combo (Control) Chart
    Please advise.

Leave a Reply

Your email address will not be published. Required fields are marked *