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.

Hidden and Empty Cells Settings

I googled it but never found the answer. Does anybody know why?

Dec 26, 2022 in Others by Kithuzzz
• 27,740 points
47 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.

Although I have not yet located it, it is someplace on this site:

enter the link description here

answered Dec 27, 2022 by narikkadan
• 51,240 points

Related Questions In Others

0 votes
1 answer

How search data in excel with openpyxl?

The method iter_rows in the library has changed, refer ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 51,240 points
941 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
• 51,240 points
158 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
• 51,240 points
101 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
• 51,240 points
166 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
• 51,240 points
90 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
• 51,240 points
72 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
• 51,240 points
191 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
• 51,240 points
58 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
• 51,240 points
243 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