Why is the series value showing up as 0, 0, 0,

[Beach Walker]

Hi

I have graphed two different results on one graph using two different axis as seen in the attachment.

The problem is the first series is not showing up on the graph, when I click into "Select Data" and then select the series that is not displaying in the graph which is "Star Rating" and click edit the series value is displayed and it shows it is coming from the correct location but the result next to it shows = 0, 0, 0, 0, 0,....

I want to display the star rating numbers on the graph but I can, can anyone help tell me what I am doing wrong.

Thanks
Data to graph.xlsx

[protonLeah]

In your formula for star ratings you have put the values in quotes making them strings. Remove the quotes:

Please Login or Register  to view this content.

[Beach Walker]

Outstanding protonLeah, spot on, it was driving me crazy

[Beach Walker]

protonLeah

I have another question, the graph column is just a line and I want it to be a thick column can you help with that?

[protonLeah]

1. I deleted the Star % series
2. Changed the range of star rating to +/-6
3. Changed x-axis from date to text
4. Modified width of star rating bars
5. Re-added star-% series
6. Changed font colors to correspond to data series.