Change the scale of the axis in a chart

Ability to change the scale of the axis in a chart in order to have a better visibility (like the option in Excel -> Axis options). The attached picture shows very well how the visibility could be improved with this option, e.g. changing the starting point of the vertical axis.

Change_the_scale_of_the_axis_38431.jpg

Comments

Miran

Status changed to: Delivered

Rebecca

Status changed to: Delivered

Rebecca

Status changed to: Delivered

simon_ritchie

Question:

In Anaplan we deal with multi-dimensional data.

If we allow the manual setting on values, what is the preferred way to handle the case when another list item is selected that has a completely different scale of data?

e.g. Product A top value is 100, Product B top value is 1000? OR Jan 2019 values average around 600 and Feb 2019 values drop to 200.

Look forward to hear some opinions from the community.

Keep the ideas coming!

Many thanks,

Cheers, Simon

Director, Product Mgmt, Anaplan

alexpavel

Thanks Simon for your interest.

Even if an Anaplan module is a multidimensional database, when a chart is built you need to choose put in the axis only one dimension per axis and focus on a particular "slice" of the cube.

Now in Anaplan, the chart scale is calculated automatically and sometimes the lines in the chart cannot be seen clearly becasue the scale is too high.

Of course if the chart scale is manually changed and in the chart page is chosen another line item the manually scale could not have sense anymore.

For example the scale for "Sales" (which have big amounts) and "Margin%" ( values between 0 to 1) line items cannot be the same.

But what is asked is the possibility to manually change this scale to be eventually lower in some particular cases and let the model builder to choose the values, similar with what can be done in Excel, and let him/her to decide if this manually modification of the scale have sense or not. 🙂

I think it would be really cool to have this possibility.

Thanks

Alex

BenHilgendorf

Any updates on this? In the New UX, there is no control over chart axes' scaling or ranges - this could be a perfect application.

kinga.markovics

I would also be interested in the result.

Is this something that'll happen & when? It's quite common to have either sales & profit in one graph or profit and profit% - both requiring different scaling. It would be very useful!

MattRobinson

You should be able to change the x-axis labels to show as "Monthly" even when the data is charted on a daily basis. This would help with de-cluttering. Example attached.

sprender

Setting the axis scale is now available in the UX in the chart settings

Quick Links

New ideas

Administration Console: Keep Last login in Date format, on top of new format
It is great to know how old is the Last Login, but: 1.It would be great to keep the old Date format as well, to be able to make more easily some ad hoc analysis (older than X days, months etc…, as shown in example further below). The filter on new format is not possible and would not be meaningfull. 2.It would be great to…
Synchronized Scroll on Worksheet with an Expanded Grid Card
It would be incredibly helpful to have the ability to group the main worksheet grid with an expanded card for synchronized horizontal scrolling. Use Case: In my worksheet, I have the Time dimension on columns and a list on rows in the main grid. I also use an expanded grid card to show a different breakdown—still by Time,…
Line Item Spacing within a Text Box
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Option to adjust line spacing within a text box. Who is this impacting? (ex. model builders, solution architects, partners, admins,…