View original (French)

Existing graphic issue not updating.

Solved
Poko -  
 Poko -
Hello,

I am working on PC Excel 2016. I have a chart with dates on the x-axis and 4 different data sets on the y-axis (dashboard of revenue).
The chart was initially created up to October 2016.
I just entered the data for November, so I selected a larger range of values.
For example, October: A1:K5
So for November A1:L5
November is checked but the chart is not refreshing, even more strangely, the curves do not stop at October but continue towards what should be November without displaying it! I can't understand what's going on because for other dashboards, I have no update problems.

PS: I had a problem with the same file where the cell calculations were not automatic, but I made the change in the options and the calculations were done, but the chart won't modify...

Thank you for your help, I was just hired this Monday, and I was given this extremely complex table to fill out today, and my boss needs it by tomorrow morning!

I cannot provide you with the file due to confidentiality.

2 answers

  1.
    Argitxu Posted messages 5292 Registration date   Status Contributor Last intervention   4 844
     
    Hello Poko

    If the data through November is well covered, maybe format the curve that stops in October

    You should be able to select the November point of the series
    Right click | Format Data Series | Fill and Line | Lines | solid line (or the line type of the other months)

    Otherwise, selected chart | Format tab | 'Active Selection' group | choose the series | Format Selection | same as above starting from Fill....

    If that's not it, nothing prevents you from providing a file with just the data range and the graph by modifying the items to maintain confidentiality
    Use https://www.cjoint.com/

    --
    Argitxu
    1
  2. Poko
     
    Thank you! Indeed, the data for the graph was limited to October in the options!
    I was able to deliver my dashboard without errors on time.
    0