Share via

Why does selecting chart not highlight data input sometimes

Anonymous
2021-10-10T04:06:21+00:00

Some charts, you click in the white space and it will highlight the data being used in the chart for all data series on that chart. Other charts it won't do this or show any of the data, selecting a given series on the chart will show you where that data came from, but not all series. I noticed this occured when I pasted the chart formatting onto one chart from another chart. Both charts have the series data in a similar/related location and all next to each other in the same format. Wonder what causes when it does or doesn't display the input data? Cheers

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

Answer accepted by question author

Anonymous
2021-10-10T06:57:09+00:00

Hi TJDack!

I'm Jen, and I'd be happy to help you out with this issue.

Has the workbook been edited in an older version of Excel? Would you be able to attach a sample file with non-sensitive data? Here's how to share a file on Onedrive.

https://support.microsoft.com/en-us/office/shar...

Thanks in advance. If you have any questions, please let me know and I'd be glad to assist you further.

Best Regards!

Jen :)

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest