×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel chart axis length
2

Excel chart axis length

Excel chart axis length

(OP)
In excel chart is it possible to specify the axis length say x-axis exactly equal to 6 inches ? Please help me how to do this.

RE: Excel chart axis length

Hi,

I suppose you can't specify the axis length directly, but you can resize the whole chart (trial-and-error?).
You can size each axis separately, by dragging in its direction.

Ari Constancio, Chem. Eng.
ari.constancio@netc.pt
http://www.terravista.pt/ancora/1588
 

RE: Excel chart axis length

(OP)
Hi Ari,
Thank you for your reply. I understood that no way is there to specify the axis length.

RE: Excel chart axis length

Kmpillai,

I'm trying to do the same thing, I think.  I wan't to be able to print the graph out so that the axis measures 6inches *on paper*.  I think there is a way, and if I figure it out I'll let you know how.  But don't wait around for me if you need it soon!

RE: Excel chart axis length

Hi, kmpillai.

If you are trying to print your chart at fixed size WITHIN ANOTHER DOCUMENT, then this suggestion will probably be of no help to you.  (Continue to watch this space, and hope that a REAL expert comes along )

On the other hand, if all you want to do is to print your chart, (and nothing else) on a single sheet, this may work for you (gleaned from the excel help section, under heading "I can't scale a chart to the size I want..."):

(a) Insert chart onto a new sheet (via 'insert' menu).

(b) Activate the new 'chart sheet' by clicking on its tab;  set the page margins from the 'file - page set up' menu, and also set the chart to be printed to fill the page (from the 'chart' tab).

By suitable adjustment of the margins you can get pretty good numeric control over the final printed width of the chart.  Some trial and adjustment may still be needed, since Excel puts a blank frame around the chart, and it is this frame which is fitted between the margins.

Good luck.

RE: Excel chart axis length

Hi  Kmpillai

This may not be the perfact solution but can generate detail required by you, It will depands how complicated your chart data is.


Excel can be used to control AutoCad, You can send your data to AutoCad and generate chart through VBA ( this will required knowledge of Autocad Object model also). This will required more effort to generate chart but it will be at a scale what we want.


Nitin Patel
India


RE: Excel chart axis length

Hello kmpillai
Yes, it is possible to do it - you'll need to use VBA

Select the chart

If the x-axis is not visible right-click the chart and from the axes tab select the x-axis radio btn.

In the Immediate window in the VBA window enter the following command:

ActiveChart.PlotArea.Width=6*72

The x-axis will be sized to exactly 6 inches (72 points = 1 inch)
Of course the Chart Area width must be more than this to accommodate the plot area. There are finer points to this, but I suggest the above should meet your requirement
mala

RE: Excel chart axis length

Another way (easy and not sophisticated) is to add a line, double click the line and size it to the required length, then pull the chart to the length of the line, delete the line and voila!
TM

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close