hello,
i constructed a graph based on a pivot table.
the data will be updated weekly.
the elements in the graph are calculated by formula after new data is pasted.
this week when the graph came out, it looked like the attached file, where the value of the two dots were clearly seen as below 10%, but on the graph it was plotted incorrectly on the Y axis.
i'm not sure if this is a scaling issue, or if some kind of set up issue i am not aware of.
any input would be appreciated.
thank you!!
Bookmarks