in reply to How to set x-axis label at the bottom(outside of chart) in a line chart

Using Win32::OLE you have access to the MS object models.

These are the steps I took to try to answer your question:

  1. Open Excel
  2. Open Visual Basic in the Developer tab
  3. Hit F1
  4. Search "Chart"
  5. Click "Chart Object Members"
  6. Click "Axes"
  7. Search "Axis"
  8. Click "Axis Object Members"
  9. Click "MinimumScale"

Now you know how to get the chart object, get the x-axis, set the minimum value to 0.

Update: it looks like you want to set the Position property of the DisplayUnitLabel where you can specify a custom position. However you use the word "labels" but I'm not sure if you mean Title. I misread your post initially, it's pretty confusing.

  • Comment on Re: How to set x-axis label at the bottom(outside of chart) in a line chart

Replies are listed 'Best First'.
Re^2: How to set x-axis label at the bottom(outside of chart) in a line chart
by satyas (Novice) on Mar 21, 2012 at 17:14 UTC

    I was trying to get perl codes to do this. I have the perl script for generating line charts fine but i cant get the x-axis labels set at the bottom(outside of chart) of the line chart.I dont want the labels to be fixed under the 0 axis. I want it outside of the chart so it will look good when there is negative values.Please let me know if you have it.

[reply]
      What did you try. Did you try manipulating the label?
[reply]

In Section Seekers of Perl Wisdom