Help with a Chart

Jerexify

Good morning. I'm having trouble conceptualizing a chart.

I have several agents, and each agent has two data points for each month of the year. I need to put a chart together that shows both data points for each month. Is this possible?

In my head, the vertical axis is the count, the horizontal axis is the months of the year, and then it would either be a side-by-side or stacked bar chart with both data points.

Not sure if this is possible within Smartsheet. If it is, how would the report be set up?

Thank you.

florian.zbinden7

hi @Jerexify ,

I tried to interpret you post ; is this what you are expecting ?

the settings are the default ones, except the chart type

it's based on this sheet

looking forward to your feedback,

best regards

Florian

Jerexify

Yes, that is what I needed. Thank you!

For some reason, I couldn't wrap my head around how the data needed to be laid out in order to get the chart to work right.

This works perfect.