line and column graph

[Fiona83]

Hi there,

I have data on an excel file that has rows containing the following data points on each column 

A) date, (B) name, (C) value (D)source name.

The source name is either "WEB" or "INTERNAL"

I need to create a line and column graph with dates on the X axis. Value on the Y axis.

How can I show the "INTERNAL" as a Bar and "WEB" as a line? But can't see how to do this

Thanks

[Datagulf]

Hello @Fiona83 ,I assume  your Column Source Name is categorical where it can only be WEB or INTERNAL.
Q. You want to display the different data sources categories separately or on the same visual?
If its on the same visual, I believe filters can work.
1. Use a Line and CLustered chart.
2. Drop the column twice on a Line and CLustered chart
3. Drop the column twice on the filter pane
. For each of the cases, ensure you filter out the other eg. 
For the bar filter out the WEB and for the Line filter out the INTERNAL. 
If this serves as the solution, please leave a like and accept this as the solution...

[Fiona83]

@Datagulf  thank you for your response. Yes, I want this in one visual.

Sorry not sure what you mean about dropping the columns twice.

Do you mean to create two visuals, and then use transparency to overlap them?

[Datagulf]

@Fiona83 , nope .. Same visual. 
what I wanted you to add twice was the column on the same visual.
This is because you are showing 2 different values( WEB and INTERNAL)in different ways, a bar and a line.

[Idrissshatila]

Hello @Fiona83 ,

use this visual Line and Clustered column Chart as in the screenshot

and you can add the field you want as a column in the column y-axis and the field as line in the ;ine y-axis

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Fiona83]

@Idrissshatila 

Thank you but when I add the source to the Y-axis is then adds this as a "count" not the value