BUG: xticks in bar plot breaks plot

[gdementen]

Pandas version checks

• I have checked that this issue has not already been reported.

• I have confirmed this bug exists on the latest version of pandas.

• I have confirmed this bug exists on the main branch of pandas.

Reproducible Example

import pandas as pd
pd.__version__
# '2.0.3'
s = pd.Series([1, 3, 2], index=[2010, 2015, 2020])
# works fine (see line.png)
s.plot(xticks=[2010, 2020])
# ticks and bars are all squashed to the right of the plot (see bar.png)
s.plot.bar(xticks=[2010, 2020])
# works fine too
s.plot.bar()

Issue Description

When using the xticks argument on a bar plot, it is kind of "squashed" to the right of the plot.
Ticks and bars are all on a single tick on the right:

For line plots, this works fine:

The issue is also present in Pandas 2.1.1 (latest stable version as of today) and Pandas 1.5.3. It might be related to #11465.

Expected Behavior

import matplotlib.pyplot as plt

fig, ax = plt.subplots()
ax.bar([2010, 2015, 2020], [1, 3, 2])
ax.set_xticks([2010, 2020])
plt.show()

Installed Versions

INSTALLED VERSIONS

commit : 0f43794
python : 3.10.13.final.0
python-bits : 64
OS : Windows
OS-release : 10
Version : 10.0.19045
machine : AMD64
processor : Intel64 Family 6 Model 142 Stepping 12, GenuineIntel
byteorder : little
LC_ALL : None
LANG : None
LOCALE : French_Belgium.1252

pandas : 2.0.3
numpy : 1.22.3
pytz : 2023.3.post1
dateutil : 2.8.2
setuptools : 68.0.0
pip : 23.2.1
Cython : 0.29.33
pytest : 7.3.1
hypothesis : None
sphinx : None
blosc : None
feather : None
xlsxwriter : 3.1.1
lxml.etree : 4.9.3
html5lib : None
pymysql : None
psycopg2 : None
jinja2 : 3.1.2
IPython : 8.15.0
pandas_datareader: None
bs4 : 4.12.2
bottleneck : 1.3.5
brotli :
fastparquet : None
fsspec : None
gcsfs : None
matplotlib : 3.7.1
numba : 0.57.0
numexpr : 2.8.7
odfpy : None
openpyxl : 3.0.10
pandas_gbq : None
pyarrow : 11.0.0
pyreadstat : None
pyxlsb : None
s3fs : None
scipy : None
snappy : None
sqlalchemy : None
tables : 3.8.0
tabulate : None
xarray : None
xlrd : 2.0.1
zstandard : None
tzdata : 2023.3
qtpy : 2.2.0
pyqt5 : None

[hvsesha]

@gdementen
s.plot.bar(xticks=[0, 20]) This works .Kindly check
import pandas as pd
import matplotlib.pyplot as plt
pd.version

'2.0.3'

s = pd.Series([1, 3, 2], index=[2010, 2015, 2020])

works fine (see line.png)

s.plot(xticks=[2010, 2030])
plt.show()

ticks and bars are all squashed to the right of the plot (see bar.png)

s.plot.bar(xticks=[0, 20])
plt.show()

works fine too

[gdementen]

s.plot.bar(xticks=[0, 20]) This works .

>>> s = pd.Series([1, 3, 2], index=[2010, 2015, 2020])
>>> s.plot.bar(xticks=[0, 20])

Produces the image below. I am confused why you consider this to be working.

Kindly check import pandas as pd import matplotlib.pyplot as plt pd.version

As I said above, I checked with 3 different pandas versions (2.1.1, 2.0.3 and 1.5.3) and they all showed the bug.

[hvsesha]

Hi If the range not starts from zero then we do have this issue My range starts from zero

[ax-va]

I write the code in the jupyter qtconsole:

import pandas as pd
mydf = pd.DataFrame(data={"col_a": [1, 2, 3], "col_b": [4, 5, 6]}, index=[1900, 1950, 2000])
mydf
"""
      col_a  col_b
1900      1      4
1950      2      5
2000      3      6
"""

mydf.index
"""
Index([1900, 1950, 2000], dtype='int64')
"""
ax = mydf.col_a.plot(kind="bar")

ax = mydf.col_a.plot(kind="bar")
ax.set_xlim([0, 10])

ax.xaxis.get_ticklocs()
"""
array([0, 1, 2])
"""
pd.__version__
"""
'2.1.3'
"""

The problem is that the Pandas' plot does not take the index of Series or DataFrame as the x-axis values but sets sequential indices starting from 0. Thus the x-axis values are wrong but the x-axis labels remain correct.

For correct plotting I should get

ax.xaxis.get_ticklocs()
"""
array([1900, 1950, 2000])
"""

That is obviously a bug in my opinion.