Addressing #40781 to raise ValueError as per discussion when a list with xlim or ylim is supplied, that contains elements in other format than integer or float type.
- [x] closes #40781 
- [x] tests added / passed
- [ ] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [x] whatsnew entry

Hello @regmibijay! Thanks for opening this PR. We checked the lines you've touched for [PEP 8](https://www.python.org/dev/peps/pep-0008) issues, and found:

* In the file [`pandas/plotting/_matplotlib/core.py`](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py):

> [Line 516:21](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L516): [E117](https://duckduckgo.com/?q=pep8%20E117) over-indented
> [Line 516:43](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L516): [E261](https://duckduckgo.com/?q=pep8%20E261) at least two spaces before inline comment
> [Line 516:44](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L516): [E262](https://duckduckgo.com/?q=pep8%20E262) inline comment should start with '# '
> [Line 516:89](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L516): [E501](https://duckduckgo.com/?q=pep8%20E501) line too long (129 > 88 characters)
> [Line 519:89](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L519): [E501](https://duckduckgo.com/?q=pep8%20E501) line too long (112 > 88 characters)
> [Line 520:32](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L520): [E131](https://duckduckgo.com/?q=pep8%20E131) continuation line unaligned for hanging indent
> [Line 520:89](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L520): [E501](https://duckduckgo.com/?q=pep8%20E501) line too long (103 > 88 characters)
> [Line 525:21](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L525): [E117](https://duckduckgo.com/?q=pep8%20E117) over-indented
> [Line 525:43](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L525): [E261](https://duckduckgo.com/?q=pep8%20E261) at least two spaces before inline comment
> [Line 525:44](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L525): [E262](https://duckduckgo.com/?q=pep8%20E262) inline comment should start with '# '
> [Line 525:89](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L525): [E501](https://duckduckgo.com/?q=pep8%20E501) line too long (129 > 88 characters)
> [Line 528:89](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L528): [E501](https://duckduckgo.com/?q=pep8%20E501) line too long (112 > 88 characters)
> [Line 529:32](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L529): [E131](https://duckduckgo.com/?q=pep8%20E131) continuation line unaligned for hanging indent
> [Line 529:89](https://github.com/pandas-dev/pandas/blob/f29161a79fb23e906fd7a84aa776d1c2947f9371/pandas/plotting/_matplotlib/core.py#L529): [E501](https://duckduckgo.com/?q=pep8%20E501) line too long (102 > 88 characters)

 @github-actions pre-commit