7 Replies Latest reply on Jul 22, 2016 11:09 AM by laura.winger.0

# Percentage of Totals + updating axis

Hi everyone, I have a simple bar chart in which I did a Table Calculation for Percent of Total. I would like my x-axis to reflect percentages, not N's. Seems to be something simple that I am missing. Any help is most appreciated.

-Laura • ###### 1. Re: Percentage of Totals + updating axis

Its just format the axis.

• ###### 2. Re: Percentage of Totals + updating axis

Hi Luciano:

Isn't it also the fact that Laura had sum(size) in the column shelf and table calculation (% of total) in the label shelf, while you have the table calculation at both the places.

Thanks

• ###### 3. Re: Percentage of Totals + updating axis

The axis is the same of shelf.

It's no possible have values of different fields in shelf and axis.

• ###### 4. Re: Percentage of Totals + updating axis

Can you look at the sheet that Laura had attached? It had Sum(Size) in the column shelf, therefore the axis had the range from 0-62.

Thanks

• ###### 5. Re: Percentage of Totals + updating axis

It's realy the same field, just shown in different ways.

My answer keeps the same.

If you need to show %, you need the table calculation (% of total) as a column

• ###### 6. Re: Percentage of Totals + updating axis

I completely agree.... Was just trying to point out why Laura was getting a different graph.

• ###### 7. Re: Percentage of Totals + updating axis

Thank you both, this worked.