How to break area chart in excel

0 votes

I've been attempting to make a broken area chart that is split. The desired result is shown in the top chart, and the data used to fill it is shown in the table attached.

Do you know the most effective strategy for getting the desired outcome? 

data1

top table is the desired outcome

Dec 17, 2022 in Others by Kithuzzz
• 28,700 points
42 views

1 answer to this question.

0 votes

Add an extra row between your areas.

Rows with 2 blank spaces between areas.

answered Dec 17, 2022 by narikkadan
• 53,160 points

Related Questions In Others

0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 22,940 points
587 views
0 votes
1 answer

How to import excel file in Oracle SQL live

Hello, there are a few steps You'll ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
737 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 53,160 points
234 views
0 votes
1 answer
0 votes
1 answer

Excel chart a line per category

Pivot charts, in my opinion, are the ...READ MORE

answered Nov 15, 2022 in Others by narikkadan
• 53,160 points
49 views
0 votes
1 answer

Showing percentages above bars on Excel column graph

Solution  Use a line series to show the ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 53,160 points
48 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
530 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
477 views
0 votes
1 answer

How to freeze an area in Excel?

Excel has a "Freeze panes" for this, ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 53,160 points
103 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 53,160 points
1,152 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP