Share via

Excel chart not displaying all data

Anonymous
2025-02-17T23:29:37+00:00

I highlighted the entire table including header B2:F14 but chart produced is only showing December and Product D. Also noticed that only column F and row 14 are coloured even though the entire table was highlighted. I would like the chart to show the entire table. Not sure why the entire table isn't represented on the chart.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2025-02-17T23:31:58+00:00

    Hi,

    Right click on the chart and go to Change Data Source. Specify the range again.

    0 comments
  2. Anonymous
    2025-02-18T07:13:28+00:00

    Thanks Ashish

    When I right clicked, the following was displayed. Couldn't see 'Change data source' but noticed the chart data range was the entire table and the entire table was highlighted too but noticed only Dec and Prod D were ticked under Legend Entries....

    0 comments