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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,114,282
Messages
5,546,960
Members
410,765
Latest member
faris99
Top