4 Replies Latest reply on Aug 5, 2018 6:52 PM by Naveen B

# Problems creating a line graph

I am trying to do a line graph, but Tableau does not show all the data points for a line graph to be produced. I am doing a line graph for goals scored against number of games played. I have done 2 attempts of these. The first (please see excel graph “Example1”) where I did number of games per season and the number of goals in that season. The next (please see “Example 2”) I did an accumulative figure  (e.g. the next season does not start from zero but carries on from the last season). Each method just shows 1 result in the line graph (the total number of games played and total number of goals- see graph below). In fact, in the accumulative graph, it adds up the accumulative figures (which of course I do not want it to). What am I doing wrong please?

• ###### 1. Re: Problems creating a line graph

HI Henry,

You are getting single dot because you are aggregating the measures and plotting check the below image unaggregate the measures to see all the points

Change the marks section to line

Hope this helps kindly mark this answer as correct or helpful to close the thread and as well it will be helpful who are looking for the same solution

BR.

NB

• ###### 2. Re: Problems creating a line graph

Hi,

When you give two measures to Tableau, it's natural to be shown a scattered plot.

If you added the "Season" row in your sheet as the dimension like this, you'd be able to make a line chart bellow.

Regards,

Y.K.

• ###### 3. Re: Problems creating a line graph

Excellent, that's sorted out the problem straight away- thanks! The next issue I have is that I I have several different data sets similar to this and I want it to be put on the same graph. The problem is that I do not know how to do this. Can you show me how to do this please?

• ###### 4. Re: Problems creating a line graph

Hi Henry,

Glad it helped, Mark as helpful and correct if it serves the purpose

if all the data sets are of same columns and same data use the union option in tableau