Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding legend changes values

Hi,

 

I have built a graph that is summarizing error data per month. I want to add a legend to show breakdown by type of error, but when I add this to the legend it changes my values.

 

Here is my graph before adding a legend

 
 

 

Here is my graph after: It changes the values to be 100% 

 

I had a previous graph in excel that looked like this, which is what I'm trying to replicate (data isn't updated which is why the numbers differ)

Any help would be appreciated!

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    In my ex[perience this happens when you either have the data type wrong or you haven't set up a relationship correctly (if you're drawing data from more than one table).  I'd check you've got your data types correct first.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    In my ex[perience this happens when you either have the data type wrong or you haven't set up a relationship correctly (if you're drawing data from more than one table).  I'd check you've got your data types correct first.