DATA VISUALIZATION

[Madhuri_Tople]

how can we show 3 axis chart 

suppose in my data there are columns like company name, week , current year sale, last year sale, last to last year sale 

i want to visualize the data 

eg for company ABC week 1 all 3 years sale should be plot in same chart

company name	week	current year sales	last year sales	last to last year sales
ABC	week 1	142	145	200
ABC	week2	439	458	451
ABC	week3	0	152	175
ABC	week4	485	425	399
XYZ	week 1	745	785	895
XYZ	week2	748	658	422
XYZ	week3	782	756	690
XYZ	week4	842	852	852

[DawnDuong]

hi @Madhuri_Tople 

I assume that you want to do the visualization in Alteryx. The Interactive Chart Tool can do that for you. You can show 3 values by defining 3 layers in the bar chart.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-output-to-formatted-sheet/td-p/5....

Dawn.

[PhilipMannering]

Hi @Madhuri_Tople 

This is how I would do it.

[Madhuri_Tople]

thank you