6 Replies Latest reply on May 13, 2013 11:30 AM by . Steveeubanks

# Can I force the Automatic Axis to make better use of the space in the graph

I have a dashboard that contains tables, charts, graphs and actions.  On load, the dashboard displays aggregated totals by date on the graphs.  Selecting an entry on a table activates a filter that causes the graphs to display departmental totals by date.  Because the departmental numbers are a small subset of the overall aggregate numbers, the scale of the graphs changes significantly when drilling down to the departmental display.

When I use an Automatic axis on the graphs, they force the line graphs to only rise to about halfway up the chart space.  This compresses the multiple lines in the chart (each line is a year), making it difficult to distinguish one line from another.  The problem is most noticeable on the aggregate charts because the year-to-year differences are smaller.  If I use a Fixed axis on the graphs, I can set a scale that allows the aggregate data to display more appropriately (using all the space in the chart), but when selecting a department, the large fixed scale is no longer appropriate.

See the attached .jpg showing the graphs with different data displayed using Automatic and Fixed axes.

Ideally, I'd like to be able to use the Automatic axis setting, but I'd like to be able to force Tableau to use all (or say, 90%) of the space on the chart to display the graph.  All that empty space at the top is wasted.

Is there any way to accomplish this?

Thanks,

-- Steve Eubanks

• ###### 1. Re: Can I force the Automatic Axis to make better use of the space in the graph

Steve, your screenshot for automatic is not the unusual behavior. Normally T sets the axis 10% above the max value. I'm thinking that something about your YOY calculation is tricking T into thinking you have higher values than you have. What calc are you using?

--Shawn

• ###### 2. Re: Can I force the Automatic Axis to make better use of the space in the graph

It's a simple SUM, graphed across Day of Fiscal Year.  Separate line for each FY by color.  See attached screenshots.  Both of these are using the Automatic axis setting.

-- se

• ###### 3. Re: Can I force the Automatic Axis to make better use of the space in the graph

What's in your Day of FY calculation? I duplicated your viz using the Super Store data:

Since you obviously don't (shouldn't) share your workbook, can you see if you can get the same behavior using the Super Store data? And then post it?

--Shawn

• ###### 4. Re: Can I force the Automatic Axis to make better use of the space in the graph

I replicated my Day of FY calculated dimension in this workbook.  Of course, the graphs display just fine here.  It looks like an anomaly of some kind in my local workbook.  It's a pretty complex workbook overall, but this particular worksheet (and others like it) are pretty simple.  I'm not sure what is in there that's causing it to behave abnormally.

I have nothing in the "Level of Detail" box, no reference lines, no extra axes.  Just one measure, one dimension, one color variable and a couple filters.

-- se

• ###### 5. Re: Can I force the Automatic Axis to make better use of the space in the graph

You should consider sharing it with support. They are good at keeping data confidential, and making sure to delete it once the case is closed (if you request it).

Good Luck,

--Shawn

• ###### 6. Re: Can I force the Automatic Axis to make better use of the space in the graph

Found it.

I was focused on the Y Axis, and didn't look closely enough at the X Axis.  When I started turning some attention there I discovered two outlying data points that were not displayed on the viz because the X Axis was fixed.  Even though the outlying data points were not being displayed (due to the fixed X Axis), they were influencing the display of the data.  When I excluded those two data points, my viz started displaying correctly.

So, while I will own responsibility for not having found the data anomaly earlier, I still think the viz should format its display according to the visible data, and not related data that is not actually being displayed at the moment, whether due to fixed axis, filter or action.