I have 4 numbers to chart which I would like to have the format of 3 different chart types in one chart. Is a way to do this? Here's the example:
Month Total 100 (this would be a bar chart)
Good parts 50 (this would be a stacked bar chart to be teamed with the 'bad parts')
Bad Parts 30 (this would be a stacked bar charat to be teamed with 'good parts')
Goal 110 (this would be a line chart)
The idea is to have the Month total next to the 2 stacked items of good and bad parts. I have easily found a way to change chart types for single numbers but am not sure the option of combining 2 of the 4 items into its own separate bar is possible. Any help would be appreciated.
Thanks in advance.
Month Total 100 (this would be a bar chart)
Good parts 50 (this would be a stacked bar chart to be teamed with the 'bad parts')
Bad Parts 30 (this would be a stacked bar charat to be teamed with 'good parts')
Goal 110 (this would be a line chart)
The idea is to have the Month total next to the 2 stacked items of good and bad parts. I have easily found a way to change chart types for single numbers but am not sure the option of combining 2 of the 4 items into its own separate bar is possible. Any help would be appreciated.
Thanks in advance.