Lines on graph updates but x axis doesn't

[ryankerslake]

I have an excel file containing share prices, and graphs to show how the shar price moves each month.

When I drag down the data for the date and share prices for the last 30 days, it updates the line on the graph to show the movement, but the date on the x axis doesn't change.

So last month, I was tracking the month of May, and the graph showed 30th May on the x axis which is correct.
This month, I'm tracking the month of June, but aftee dragging down all the data up intil 30th June, the x axis is still showing 30th May, when it should be showing 30th June


In the settingns, i've tried editing the bounds, and manually typing in the number format for 30th June, which is something like 44377.
When I entered this mannually in the 'bounds' section on graph settings, it still didn't update the date.

I also chdcked that the axis is selected as automatic in the settings

I can't share an image as it's for work and therefore the data is confidential

thank you

Ryan

 

[GraH]

Maybe you can sanitize the data first then share a picture?

Why not simply use a pivot chart with time slicer? No need to do any dragging whatsoever.