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
• 38,010 points
1,163 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
• 63,700 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
• 63,700 points
6,128 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,700 points
856 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,700 points
571 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,700 points
842 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,700 points
654 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,700 points
565 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,700 points
666 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,700 points
12,527 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,700 points
1,224 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