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
• 38,010 points
170 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
• 63,420 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
• 23,260 points
2,876 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
• 23,260 points
1,599 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
• 63,420 points
777 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
• 63,420 points
204 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
• 63,420 points
253 views
0 votes
1 answer

Arrange charts position in 3x5 order

Your code was nearly complete. I believed ...READ MORE

answered Apr 9, 2023 in Others by narikkadan
• 63,420 points
228 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
830 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
• 63,420 points
401 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
• 63,420 points
2,968 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