I have created a Report Definition to pull the data from the table and included chart. But I am not seeing the options in Pega to include both line and bars in the same chart. In MS XL, We can make different chart types for each column and altogether it will be displayed in the same chart. PFA.
Combo charts let you combine a column chart and a line chart in a single display. In a combo chart, the values for one aggregated numeric column appear as columns on the chart, and the values for another aggregated numeric column appear as lines. In Single Y-Axis combo charts the same scale applies to both columns and lines; in Dual Y-Axis charts different scales are used for the columns and lines.