Forum Discussion
Some Data Point not showing on Line Chart
Anonymous
The issue is the data point fails to show on the chart, the data for these particular KW exists in the table but somehow its not depicting on the graph.
To explain my data model, i have a group of product together with their weekly sales YTD and also the % shares of these products for the company.
To make a sample because its sensitive:
| Product Name | QTY | Sales | KW | % Shares |
| Product A | 656 | 15,000$ | 42 | 90.8% |
| Product B | 200 | 1308$ | 42 | 67.4% |
| Product F | 342 | 2848$ | 35 | 56.0% |
| Product X | 5881 | 15,688$ | 44 | 90.9% |
To relate this to the chart in my original question, the black line is % Shares column and the green line is the Sales. Now, i dont understand why KW 42 and Kw44 are not showing on the chart even tho i have the data in the table. (In an entirely different tab/chart, I am able to see all the data points)
- Anonymous4 years agoNot applicable
Hi foyadeyi ,
I have a test by your data. It works well in my side.
Please check whether there are some filter in Sales.
And you can download the latest version Desktop and try again.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous2 years agoNot applicable
Did you ever find a solution to this? I'm having the same issue in Powerpoint and nothing I try seems to work.