Normally Excel gives the variety of charts (apple pie, bars, radar etc.) but in the chart all the series are displayed in the preselected mode.
I'd like to know if it is possible to have mixed types of charts in one and namely:
if I have e.g. two series, one of them is to show the real monthly results in the period from January to June and it should be shown by bars whereas the second series is to show the target objectives, which should be shown by a red line.
Is it possible to do this in Excel?
Thanks a lot for your suggestions!