HELP! Excel Question?

Question

How do I put multiple data in a single cell? My x axis is the calender months and I need to put multiple dates under a single month

Answer 1

You can enter multiple values in a single cell by entering them as text with separators but there would be no way to get a chart to recognize the separate values.  If you are trying to show the sum of values for several or all days of a month at a single x axis value, there are two ways you can accomplish that.  Both require that each day be in a separate column with all days of a month in the same row.

Then your choices are to use a sum (of all days) column for the y values or to use all of the day values for a stacked chart of y values.  The first choice is simpler but the second shows each days contribution to the total (if you can identify separate days in the stack.)