Why doesn't the pie graph and bar chart always display the same data when the same data is selected?

I have 8 columns that have been summarized. I used a pie graph to display the 8 columns as a percent. I then tried to use a bar chart to display the 8 columns as a dollar amount. However, the bar chart will only display 7 of the columns. Any ideas what may be causing this?

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Are you able to provide a screenshot of how you are setting up the bar chart? There should be a checkbox that indicates whether or not to use the first column as the labels.

    thinkspi.com

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Are you able to provide a screenshot of how you are setting up the bar chart? There should be a checkbox that indicates whether or not to use the first column as the labels.

    thinkspi.com

  • Thanks, Paul. I somehow missed the checkbox.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com