A few days ago
Anonymous

2 values in one cell in Excel! HELP!?

I am trying to create a scatter chart that represents the dates pennies were minted and their mass. If for the year 1995 one penny had a mass of 2.4 and another of 2.5 how do I insert these two values in for 1995? So that when I make the graph there will be two dots over 1995. I am new to scatter charts so I don’t know it this is allowed. Help anyone? I tried to separate 2.4 and 2.5 with a comma but that did not help. Thanks!

Top 1 Answers
A few days ago
FALL

Favorite Answer

I think you have to put them in separate cells or columns. So for 1995 you would have two entries 2.4 and 2.5 but for 1996 you might only have one entry.
1