Hi Team, This is my Table on excel - TotalCarBike Bus02-09-20191476103-09-2019 21801304-09-201942643205-09-2019314111606-09-20191019009-09-201926422010-09-201930381911-09-2019321121912-09-201919310613-09-201931802316-09-201923181417-09-201921541218-09-201918141319-09-2019722320-09-201929112723-09-201919451024-09-201917431025-09-20191223726-09-201914041027-09-2019321022030-09-2019161093 I want to create a chart exactly like this that I've created in excel? If you could please attached your Workflow.

Alteryx Charts workflow

Hi Team,

This is my Table on excel -

	Total	Car	Bike	Bus
02-09-2019	14	7	6	1
03-09-2019	21	8	0	13
04-09-2019	42	6	4	32
05-09-2019	31	4	11	16
06-09-2019	10	1	9	0
09-09-2019	26	4	2	20
10-09-2019	30	3	8	19
11-09-2019	32	1	12	19
12-09-2019	19	3	10	6
13-09-2019	31	8	0	23
16-09-2019	23	1	8	14
17-09-2019	21	5	4	12
18-09-2019	18	1	4	13
19-09-2019	7	2	2	3
20-09-2019	29	1	1	27
23-09-2019	19	4	5	10
24-09-2019	17	4	3	10
25-09-2019	12	2	3	7
26-09-2019	14	0	4	10
27-09-2019	32	10	2	20
30-09-2019	16	10	9	3

I want to create a chart exactly like this that I've created in excel? If you could please attached your Workflow.

Workflow

Help

Accepted answers

danilang

Hi @clarrock

While the graphing capabilities of Alteryx are improving, it's real strength lies in data prep and analysis. Here's the closest I could easily get.

Dan

BarAndLine.yxmd

danilang

@clarrock, @henrygeorge

The dual axis was added in Version 2019.3. I can't find the earliest version for the transforms feature

Dan

All comments

danilang

Hi @clarrock

While the graphing capabilities of Alteryx are improving, it's real strength lies in data prep and analysis. Here's the closest I could easily get.

Dan

BarAndLine.yxmd

clarrock

@danilang

When modifying the data. Why isn't my chart modifying. It still remains the same. Try to put a negative number in one of the columns.. The chart doesn't change.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335