WebDec 19, 2024 · Jan 14, 2024. Have been using excel to PDF to generate reports for the longest time via the >file >save as > PDF. Somewhere over the past week my graph data points fail to display on the report. See image below. Its a requirement that i have these data points on the report. If i go file > print > microsoft print to PDF it includes these points. WebApr 22, 2024 · The data shows up as being part of the data series and the legend for the missing line is present, just not the actual line of data. I have tried to do: 'Select Data/ Hidden and Empty Cells/ Connect data points with line' but can't get the last data to show …
Create a Line Chart in Excel (In Easy Steps) - Excel Easy
WebApr 30, 2024 · Nov 15, 2013. Messages. 678. May 17, 2024. #6. Hello mtodorova13 - Looking at your graph it looks like the months that are displaying are: 07, 04, 01, 10 then repeat 07, 04, 01, 10. It looks like the next date that will show on your graph in this series is 10-17. You might try adding fake data up to November of 2024 and see if 10-17 shows … WebMay 12, 2009 · Im having trouble getting lines between my datapoints to show. I have tried rightclicking the data point -> Format Data Series and then tried both Automatic and … check my stop and shop gift card alcohol
A Line chart may plot gaps in lines when the data range contains blank ...
WebShow or hide a data table. Select a chart and then select the plus sign to the top right. To show a data table, point to Data Table and select the arrow next to it, and then select a … WebWhen you type a number into a cell, Excel usually recognizes it as a number and internally stores it as one. Excel then knows that it is a number and can use it in charts and other mathematical calculations. If the cell has been formatted as Text, Excel won’t do this. WebNov 12, 2013 · The trick is to have a formula like the following. =IF (B4=0,NA (),B4) Where B4 is your source data. Excel will not plot NA (). Will attach a file to show workings. Alternatively you could group the columns if they are zero. Excel will not plot hidden columns/rows. That is all I got. Take care. check my stimulus payment status