Chart and Data are not lining up

indiemusicboy

New Member
Joined
Apr 9, 2020
Messages
47
Office Version
  1. 365
Platform
  1. MacOS
Hello! I have a Chart problem. I'm trying to show the data in Fig A in a line chart in Fig B. I'm using 2-D Line 100% Stacked chart.

But as you can see the numbers from Fig A are not matching the legend, colors, nor numbers in Fig B.

Fig C is my chart data input.

What gives?

Is my data messed up or is my use of the chart incorrect?

Fig A
Screen Shot 2020-04-10 at 6.25.25 PM.png


Fig B
Screen Shot 2020-04-10 at 6.23.07 PM.png


Fig C
Screen Shot 2020-04-10 at 6.26.43 PM.png
 

Attachments

  • Screen Shot 2020-04-10 at 6.15.33 PM.png
    Screen Shot 2020-04-10 at 6.15.33 PM.png
    57.7 KB · Views: 1
  • Screen Shot 2020-04-10 at 6.16.18 PM.png
    Screen Shot 2020-04-10 at 6.16.18 PM.png
    34.4 KB · Views: 1

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
What should your chart be like according to you? What do you want to show? What is that target of 86% about?
Default distributions examples are like, but I doubt that is what you want:
1586603521126.png
 
Upvote 0
The presales, delivery, adoption and support are 4 phases in a customer journey (beginning to end).

I am measuring customer/employee (asset, AE, PM, Engineer) satisfaction in each phase.

Satisfaction if is measured in 0-100 range.

I want do do a line chart because the visual is most conducive to a map; up down continuous line. But as you can see, even in your example the data is displaying in different numbers than in the data.
 
Upvote 0
However as you can see, even in your example (and mine), the chart is displaying in different numbers than in the data.
  • It should not go over "100" (like it does in yours);
  • it is sometimes half the number in the chart than it is in the data range; and
  • the customer/employee data range are different in the chart meaning it says Asset but its pulling Engineer data.
 
Upvote 0
Remember I could not guess what those numbers represented and I went with your stacked one.
Simply do not stack and go for a bar chart.

1586633823409.png
 
Upvote 0
As I said in reply #5, do not use a stacked version... Simple line chart will do.
Though I doubt it is the best choice to present your data.
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top