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,000 points • 391 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,600 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 • 4,146 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 • 2,142 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,600 points • 1,348 views
0 votes
1 answer

How to lock data in excel sheet using POI, leaving cells without any data / the rest of the sheet unlocked

If the cells in a row have ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
 • 63,600 points • 3,526 views
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,600 points • 403 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,600 points • 496 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,600 points • 587 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 • 1,212 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,600 points • 706 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,600 points • 3,722 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
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.