Skip navigation

My Learning Blog

December 28, 2017 Previous day Next day

For some time I worked for someone who disliked graph legends and preferred putting labels for lines and bar directly in graph.  It is definitely easier to read in many cases, especially with line graphs.

 

After my ordeal with adding markers to a line, I wasn't optimistic about easily adding the labels where and how I wanted them in my Football Player Retention graph, but thankfully, I was pleasantly surprised.

 

First, I dragged the Grad Class dimension to the Label square of the Marks pane (in the All section).  I then left-clicked the Label square to pull up a formatting pane.  This allowed me to customize the text - I set to say "Grad Yr" in front of the number coming in from the data.  I then moved down to Marks to Label and selected Line Ends.  Additionally, I could specify if the labels were to be placed at the start and/or the end of the line.  Awesome!

 

 

I like putting markers on data points in line graphs.  Especially where a line is relatively flat, it makes it much easier to see and compare different data points on the graph.  Over the years, I have cursed Excel's graphing tool on many occasions, but it was pretty easy to add and change the style and formatting of data point markers, so I was really surprised this was such an ordeal in Tableau as I was working on my Football Player Retention viz.

 

Clicking the color box in the Marks pane did pull up an option to add a marker, but it was just a small circle one.  I then read in the Tableau forum that I really needed to add my measure to rows a second time and put that second pill on a dual axis - I'm pretty sure I did this by clicking the arrow in that second pill in the row.  But this created other issues.  I now had two vertical axis titles and two sets of tip tools showing up when I hovered over my graph.

 

Getting rid of the right hand axis title was a quick fix.  I'm pretty sure I right clicked the axis then unselected Show Header.  Let's hope I don't want that axis title again, because I can't figure out how to make it show up again.

 

The tip tools were more problematic.  I ended up going to "All" in the Marks pane and clicking on the Tool Tip square.  This allowed me to edit what I wanted in the tool tip.  However, I was still stuck with the second tool tip that appeared when I hovered over just the line - it was missing one of the elements, so I didn't want it to show.  What finally worked was going to the section of the Marks pane with the line, clicking on the Tool Tips square and deleting everything in the edit area.

 

I haven't gone into having different markers for the various lines - that's a battle for another day.

 

Come on Tableau!  This should be much easier!

 

 

While I was working on my first viz (a map), I happened across a place where I could add in Census to my map.  It drove me crazy when a week or so later I couldn't find it again, but at last, I figured it out.  

 

Go to Maps (in top menu) and select Map Layers from within the Maps menu.  This will pull up the Map Layers pane on the left side of the worksheet.  Go to the pull down menu under Data Layers to see the various types of Census data available.

 

I have yet to delve into this cool little tool, but at least I'll be able to find it again when I'm ready.