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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,114,073
Messages
5,545,827
Members
410,709
Latest member
Mrsamir
Top