Graph scale range formula

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

javiersan
Posts: 184
Joined: Mon Jan 19, 2009 8:18 am

Graph scale range formula

Postby javiersan » Tue May 18, 2010 9:18 am

Hello,

I want to include text within charts, for example, on a horizontal bar chart a data value (not necessarily the plotted one) to the left (if<0) or right (if>0) of the bar.

In order to calculate the position of the text I need to know the chart's axis range and I would like to know what is the formula that you use for determining the max/min and step size when the automatic option is selected. Would you be so kind to reveal it?

Thanks,

Javier

EViews Pamela
EViews Developer
Posts: 54
Joined: Wed Sep 17, 2008 2:52 pm

Re: Graph scale range formula

Postby EViews Pamela » Tue May 18, 2010 9:59 am

The algorithm is quite complicated, and cannot be summed up easily.

Pamela

javiersan
Posts: 184
Joined: Mon Jan 19, 2009 8:18 am

Re: Graph scale range formula

Postby javiersan » Tue May 18, 2010 2:03 pm

:shock:

Is there a way then to know what is the range of a given chart?

Excel apparently uses this algorithm:
http://support.microsoft.com/kb/214075

Regards,

Javier

EViews Pamela
EViews Developer
Posts: 54
Joined: Wed Sep 17, 2008 2:52 pm

Re: Graph scale range formula

Postby EViews Pamela » Tue May 18, 2010 2:19 pm

We offer a command to set the min/max, but not a routine to retrieve it.

javiersan
Posts: 184
Joined: Mon Jan 19, 2009 8:18 am

Re: Graph scale range formula

Postby javiersan » Wed May 19, 2010 3:30 am

Hi Pamela,

Is this feature (retrieving max/min values of chart) something you could include in future releases/patches?

Thanks,

Javier

Niek
Posts: 1
Joined: Wed May 02, 2012 6:16 am

Re: Graph scale range formula

Postby Niek » Wed May 02, 2012 6:20 am

Hi,

Is it possible yet to retrieve the minimum and maximum values of the range of a graph axis, when these are automatically chosen by Eviews?

Kind regards,

Niek

EViews Glenn
EViews Developer
Posts: 2672
Joined: Wed Oct 15, 2008 9:17 am

Re: Graph scale range formula

Postby EViews Glenn » Wed May 02, 2012 9:22 am

Unfortunately, no.

javiersan
Posts: 184
Joined: Mon Jan 19, 2009 8:18 am

Re: Graph scale range formula

Postby javiersan » Thu May 03, 2012 4:31 am

It is a pity that this functionality is not available. One of the possible uses is when you want to convert the dimensions [date,y-axis] of a chart to virtual pixels in order to assign text to a data point in a chart (say at the peak value of the NASDAQ add a text that says "peak") one can interpolate the x position via @pagesmpl but the y position is not possible unless the chart axis is set to minmax and this may not be what one wants.

It shouldn't be too difficult to assign to a graph object scalar attributes such as @minleftaxis, @maxleftaxis, etc.

EViews Glenn
EViews Developer
Posts: 2672
Joined: Wed Oct 15, 2008 9:17 am

Re: Graph scale range formula

Postby EViews Glenn » Thu May 03, 2012 9:11 am

We'll make a note of the suggestion. Thanks.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 14 guests