Is there a way to replicate an Excel combo chart in Domo?

I have some charts in Excel I'm trying to replicate (as best I can) in Domo. One of the charts is a combo chart that shows data on the Primary and Secondary axis. Is this possible in Domo? I'd like to have a vertical bar and a line on the same graph.

Find more posts tagged with

Accepted answers

Godzilla

You have multiple options to do this. You can have a simple bar + line chart. You can do a stacked bar + line as well as grouped bars + Line. The stacked bars can show actual values or % breakdown(i.e. region/channel breakdown by %). You can also add multiple lines on each of these charts.

PLaPlant

@user01332 I apologize as this was lost in the middle of a lot of other work. I'm not sure if you already found your answer but wanted to respond just the same. I set my data up as follows:

Quarter	Series	Value
2015 Q1	Category 1	189
2015 Q2	Category 1	190
2015 Q3	Category 1	178
2015 Q4	Category 1	170
2016 Q1	Category 1	175
2015 Q1	Target Category 1	165
2015 Q2	Target Category 1	165
2015 Q3	Target Category 1	165
2015 Q4	Target Category 1	170
2016 Q1	Target Category 1	170
2015 Q1	Category 2	138
2015 Q2	Category 2	134
2015 Q3	Category 2	136
2015 Q4	Category 2	140
2016 Q1	Category 2	131
2015 Q1	Target Category 2	120
2015 Q2	Target Category 2	120
2015 Q3	Target Category 2	120
2015 Q4	Target Category 2	125
2016 Q1	Target Category 2	125

The first column was my date range (in my case just 5 consecutive quarters). The 5 quarters would be repeated for each of the series in column 2.

Column 2 represented my series and the series target.

Column 3 had the values for the series in column 2.

Once the data is imported into Domo I chose the Line + Grouped Bar option.

My date range was in the X Axis

The Y Axis is my values

The series would then be the series from Column 2.

Under Chart properties under General I chose:

Series on Left Scale = 2

Sync Value Scales was checked as both my line lines (which represented the targets) and the bars (which represented the actuals) had the same scale

I then checked Hide second scale as I didn't need to see both.

Hopefully this helps.

All comments

Godzilla

PLaPlant

Godzilla, thanks for the update. I played around with the Group Bar + Line chart and realized that I needed to manipulate the data in Excel in order to get the data the way I wanted it. I needed 2 bars and 2 lines. The bars represent the actuals and the lines the targets. By setting up the data in a specific format in Excel I got it to work by using that import as my data source. Thankfully this data is only updated once a quarter so I don't need it to link to live data.

user01332

@PLaPlant I need to build a card with 2 bars and 2 lines. Can you please share what steps/options you used to build yours?

kshah008

@user01332, please feel free to open up a new thread for better exposure to your question ?

PLaPlant

@user01332 I apologize as this was lost in the middle of a lot of other work. I'm not sure if you already found your answer but wanted to respond just the same. I set my data up as follows:

Quarter	Series	Value
2015 Q1	Category 1	189
2015 Q2	Category 1	190
2015 Q3	Category 1	178
2015 Q4	Category 1	170
2016 Q1	Category 1	175
2015 Q1	Target Category 1	165
2015 Q2	Target Category 1	165
2015 Q3	Target Category 1	165
2015 Q4	Target Category 1	170
2016 Q1	Target Category 1	170
2015 Q1	Category 2	138
2015 Q2	Category 2	134
2015 Q3	Category 2	136
2015 Q4	Category 2	140
2016 Q1	Category 2	131
2015 Q1	Target Category 2	120
2015 Q2	Target Category 2	120
2015 Q3	Target Category 2	120
2015 Q4	Target Category 2	125
2016 Q1	Target Category 2	125

The first column was my date range (in my case just 5 consecutive quarters). The 5 quarters would be repeated for each of the series in column 2.

Column 2 represented my series and the series target.

Column 3 had the values for the series in column 2.

Once the data is imported into Domo I chose the Line + Grouped Bar option.

My date range was in the X Axis

The Y Axis is my values

The series would then be the series from Column 2.

Under Chart properties under General I chose:

Series on Left Scale = 2

Sync Value Scales was checked as both my line lines (which represented the targets) and the bars (which represented the actuals) had the same scale

I then checked Hide second scale as I didn't need to see both.

Hopefully this helps.