Different Way of Chart Preparation in a Single Data Sheet

joeyjee

Board Regular
Joined
Sep 20, 2013
Messages
63
Dear friends,

Not sure if we can use different chart type for a set of data?

For example, for year 2020, I would like to use bar chart to present the numbers for each month, while year 2019 I would need the data to be presented using line chart.

Is it possible?

I have attached a screenshot for your reference.



Thanks,
Joey
 

Attachments

  • Cap.GIF
    Cap.GIF
    20.4 KB · Views: 2

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,118,415
Messages
5,571,973
Members
412,430
Latest member
Huuktkt
Top