Excel Connect data points with line is DISABLED

0 votes
In Excel, I have a graph for a prepared table.

The "Connect data points with line" option are disabled, and I'm experiencing the traditional problem of empty numbers being displayed on the graph as zero. I can't verify it.

I googled it but never found the answer. Does anybody know why?
Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,655 views

1 answer to this question.

0 votes
By replicating the data series and substituting zero values with #NA, I was able to get around a similar issue, and my chart then functioned as intended.
answered Dec 27, 2022 by narikkadan
 • 63,600 points

Related Questions In Others

0 votes
1 answer

What are the main reason why python is becoming more popular as compared top R or Java with regards to Data Science?

First of all, Java is not used ...READ MORE

answered Apr 8, 2019 in Others by Vardhan
 • 13,150 points • 900 views
0 votes
1 answer

How search data in excel with openpyxl?

The method iter_rows in the library has ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
 • 63,600 points • 7,109 views
0 votes
1 answer

Create charts in excel sheet [ in same sheet along with data C#]

Unfortunately, it's not that simple. Use the ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
 • 63,600 points • 1,166 views
0 votes
1 answer

Create unique rows in Excel with limited data to be used in multiple columns

This setup isn't readily generalizable, though since ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
 • 63,600 points • 730 views
0 votes
1 answer

Excel Pie-Chart in categories

create a pivot pie chart. You can manually ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
 • 63,600 points • 1,120 views
0 votes
1 answer

Create Graph from data in an excel file

Your first step would be to become ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 820 views
0 votes
1 answer

How to create a bar graph in Excel 2010 by counts?

Read on usage of pivot charts: Procedure: Pivot Table: Select Data Insert ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
 • 63,600 points • 767 views
0 votes
1 answer

Using Java to create PDF graphs based on Excel formulas

The Apache POI project, an API for ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
 • 63,600 points • 827 views
0 votes
1 answer

What is the easiest way to convert an Excel spreadsheet with tabular data to JSON?

Assuming you really mean easiest and are not necessarily ...READ MORE

answered Dec 29, 2022 in Others by narikkadan
 • 63,600 points • 13,428 views
0 votes
1 answer

Protect excel sheet but allow data entry with form

Try this: Private Sub Workbook_Open() ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
 • 63,600 points • 1,566 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.