Excel 2007 :: Horizontal Align X Axis Title To Plot Area VBA?
Jun 16, 2012
We have a lot of charts we want to create in Excel 2007. We have templates created that seem to work. (But also sometime seem to not.)
After the charts are created that are placed in their own chart pages/sheets. The problem I'm having is that the x axis title doesn't seem to be centered horizontally wrt the x axis of the plot area. (It does look centered wrt the chart area.)
Some code or an algorithm to control he placement of the x axis title and maybe center it?
View 9 Replies
ADVERTISEMENT
May 13, 2014
I've put together code to construct a chart
It all works fine but I've noticed an odd quirk which I can't explain nor can I seem to fix. Here's the (reduced) code :
Code:
Dim appExcel As Object ' Excel Application
Dim chtPareto As Object ' Chart
Set appExcel = CreateObject("Excel.Application")
Set chtPareto = appExcel.Charts.Add
With chtPareto
' Primary category axis
[code]....
The category (x) axis title should be horizontal, whereas the value (y) axis title should be rotated. Stepping through the code, when I .SetElement for the category axis title, it appears horizontal as planned. However, as soon as I .SetElement for the rotated value axis title, the category axis title also rotates.
View 3 Replies
View Related
Jan 29, 2010
how to resize the plotarea of a chart so that it wont overlap with the title. I can't seem to find the appropriate property to let me determine the height or the bottom edge of the chart title.
View 2 Replies
View Related
Aug 24, 2012
I am working with the Ganntt chart and horizontal bar charts but can't seem to figure out a way to force the X-Axis to behave properly.
In Excel 2007, I am trying to get the X-Axis to show major units of Months. However, in my chart options I can only change the Y-Axis to be Date/Monthly.
Changing my data layout (from the below) to be a vertical format produces the same problem, just in the other direction.
My data looks as follows:
System
Blocker
Production
Migrataion
Retired
Sys1
1/1/2012
780
Sys2
1/1/2012
400
60
90
Sys3
2/1/2013
30
5
1
The Blocker column is formatted as "No Fill" in order to cover a portion of the time-scale.
My X-Axis displays as random dates throughout the period and all of my data displays properly in terms of the scale on the grid.
What is NOT working is that the dates shown on the X-Axis really need to be based on a Monthly scale instead of the randomly selected dates Excel is using.
20120823.xlsx
I can't seem to find the right combination of options to make that happen or force a scale on the X-Axis.
View 1 Replies
View Related
Jun 29, 2014
I'm using Office/Excel 2004 on a Mac Mini duo running OS10.6.8. I upgraded to Office/Excel 2011 but I find the program so horrible I had to switch back to 2004.
The problem: On one chart, the Y-axis label values have moved from outside the left-hand axis to _inside_ the right-hand axis and within the plot area. I can't figure out how to move the labels back to the right position.
View 5 Replies
View Related
May 16, 2008
This seems so simple but i looked everywhere and i cannot find the vba script to add a 3 point solid black line border around the chart and plot area of my graphs. The record macro option does not record this.
View 3 Replies
View Related
Apr 12, 2014
I'm having trouble getting the dates i want on the horizontal axis on a chart in Excel 2013. I want 12 dates along the axis starting at 01/01/2013 then each month until 1/12/13 however as you can see the dates are 01/01/1900.
View 10 Replies
View Related
Mar 1, 2014
I have a spreadsheet with golfers handicaps, golfers names down the left in column A in rows 3-35. Row 2 has the event numbers titles 1 to 18 (18 events in a year). i need a graph that has the person as the vert axis and the horizontal axis needs to be the event numbers, so i can read down for the person and across to see how there handicaps change from each different event. i have attached the data below.
View 1 Replies
View Related
Jan 28, 2013
I recently switched to Excel 2010 and have a rather peculiar problem.Every week I update a bunch of charts in different workbooks. By update, I pretty much mean just shifting the range over one column or down one row to incorporate newly added data.
So I right click the chart, select "Select Data", update all the Data series ranges and then I click on the Horizontal (Category) Axis Labels button "Edit" to update the Axis label range.
I do all that then press OK. The data series have updated, but the axis labels haven't. So then I do the procedure again for the Axis Labels, hit OK again and voila: It worked.
But I ALWAYS have to do this procedure twice. It will NEVER update the axis labels the first time around. Even though the little preview window below the edit button show the labels correctly.
View 1 Replies
View Related
Jan 16, 2013
We make many graphs using XYscatter charts with lots of data points using Excel 2003 with the horizontal scale properly scaled as frequency. I have been asked to label that axis in some way as period (=1/frequency) without changing the scaling for the data plot. Is there a suitable way to do this? It would be OK to just change the axis numbers to 1/frequency computed from them automatically. Is Excel 2010 any easier for this?
View 9 Replies
View Related
Jan 26, 2008
What is the best way to have both horizontal and vertical axis as value axis?
View 2 Replies
View Related
Apr 1, 2014
I would like the full path in the excel 2007 title bar automatically every time I open a excel file.
The macros I try from other sources all end up in errors. I need step by step instructions.
View 6 Replies
View Related
May 29, 2014
I have a report that has a set template except that the number of columns change.
I have 3 rectangular shapes with text boxes inside each rectangle. The Shapes take up space vertically between row 8 and 15. In some reports the columns will change, the size of columns might change due to longer text. Is there a macro that will select all the shapes and text boxes and center them column wise between the print area?
View 1 Replies
View Related
Apr 10, 2014
I have a data series plotted as columns. Then I want a horizontal line at $5,000 to appear all the way across the chart. It appears from the 1st to the last data point, but there is blank space before the first point and after the last point. I would like the red line to extend into this blank space before and after, so that it is going across the entire chart.
I tried playing around with different axis settings and no luck.
View 2 Replies
View Related
Mar 15, 2012
I have data that starts from say, 17:50 hours. However, I would like the chart to start from 00:00 to 00:00 so it is a full 24-hour period. So up to 00:00 to 17:50 hours, it would be blank then the data will be plotted from 17:50. How do I do this? If I select the existing data from 17:50 and ask Excel to create a chart, the x axis starts from 17:50 (not 00:00).
View 4 Replies
View Related
Jun 18, 2007
I'm not getting all of my text into the Axis title "box" in a normal graph in excell. And I'm not able to use the arrow to "drag" the axis title to a larger area. Making the size of the text smaller is not a option, I would like the axis title area larger.
View 3 Replies
View Related
Jul 19, 2014
I have a basic line chart. It was generated without a horizontal axis title, and very little room to add one. When I add one, the chart won't resize for it, and it bumps into the numbers on the axis. How do I get the chart to resize so this axis title fits in nicely. This has proven to be surprisingly difficult. Note also that a lot of options are greyed out that I try, and so far un-degreyable.
View 7 Replies
View Related
Mar 8, 2012
Basically I have some performance figures for a fund that I want to make a chart for, the problem is that the first date (the start date of the fund) is 15/09/2011 but every reporting date after that is the end of the month.
So my data looks something like this (not real figures)
15/09/11 20
30/09/11 22
31/10/11 23
30/11/11 25
31/12/11 26
31/01/12 27.5
29/02/12 29
So what I want is a graph where the x axis starts at 15/09/11 but then the next label is 30/09/11 and 31/10/11 etc, while still keeping the scale proportionate to the dates, ie the distance between 15/09/11 and 30/09/11 will be half the distance between 30/09/11 and 31/10/11.
The 2 outcomes I seem to be stuck with is either forcing the graph to start at 31/08/11 and making the y axis cross at 15/09/11, however with this the x axis goes left past the y axis cross point and it just looks dumb, although everything right of the y axis is correct.
Or secondly I get the graph to start at 15/09/11 and set it to label every 1 month and all the labels are 15/09/11, 15/10/11, 15/11/11 etc
I have access to excel 2003 or 2007.
View 4 Replies
View Related
Dec 4, 2012
I am having a problem when making a XY-plot diagram because I want text values on the x-axis instead of numbers - but that doesn't seem to be possible to get with this type of diagram?
View 2 Replies
View Related
Jan 16, 2007
im having problem formatting my graph.
chart type = line.
I have 1 series of data, which is N values vs. Time.
Time however, is specified by specific dates. The graph is not putting a plot point accorrding to the date corresponding to the N value.
Example values:
date:____1/1/05 _______ 5/7/05 _____ 8/13/05
n value: __55 ___________ 22 _________ 11
I want the chart to reflect the time between the dates and put a plot point (n value) under each date listed and connect with a line.
View 9 Replies
View Related
Jul 27, 2007
Attached is a chart I am trying to create. So basically, I originally used a line chart but it didn't have the flexibility of the scatter chart, but i am having a very hard time formatting the X axis. First of all - I would like the line in the middle at the 0% point to actually go to the bottom so that the x axis labels aren't in the middle of the graph. Second the x axis labels aren't showing up correctly. They should be quarters: 1Q:02, 2Q:02, 3Q:02, 4Q:02... Finally, how can I show the correlation between these two data points plotted - the R-squared. THANKS!!! Auto Merged Post;I actually was able to figure out most of what I asked. What is remaining: how do I calculate the R-Squared on the chart? Isn't there a way to do it automatically in excel on the chart.
View 3 Replies
View Related
Jan 13, 2009
I follows Andy Pope Methods to make average line,
Q.1 To make the line span across plot area continue…
I can not find solution, trying different options.
Please let me know how to do it?
Q.2 Question related to Average
If value is zero the, how to make average excluding zero by excel functions.
View 12 Replies
View Related
Jan 3, 2012
I'm trying to format the plot area of a X-Y scatter chart in a three colour gradient (Green, Yellow & Red).
The trick is, I would like the green portion to be centred in a user defined place on the plot with the yellow radiating from it, and the red radiating from the yellow. Ideally I would like to define some stops for the green as a user defined shape, with stops for the yellow outside the green stops (like the % stops you get in a vertical or angled gradient, but instead of the stops being simple straight lines or concentric circles from the middle, they would be user defined shapes).
I can do the normal types of gradient, but have no idea how to customise them in this way.
View 5 Replies
View Related
Oct 26, 2006
I have plenty of experience with VBA outside of charts so that's where I need assistance. I need to get SeriesCollection(4), the PTAI series, to appear on the area chart second from the bottom instead of on the top.
The order for the non-line series should be, from top to bottom:
SeriesCollection(3) - Non-Mission AC ( Training, T&E, AMarc series)
SeriesCollection(2) - Total Pipeline series
SeriesCollection(4) - PTAI series
SeriesCollection(1) - Available PMAI series
Here's the
Sub MakeSandChart()
Dim ChartSource As Range
Dim ChartName As String
Dim ChartSheet As String
Dim yCount As Integer
Dim PAA_Value As Integer
Application. ScreenUpdating = False
passtype = Mid(ActiveSheet.Name, 5, 1)
Set ws = Worksheets(ActiveSheet.Name)
ChartName = Left(ActiveSheet.Name, 5)
ChartSheet = ChartName & " Chart"
ChartName = "F18" & passtype
Set ChartSource = Union(Range("SummRowDate" & passtype), _
Range("SummRowTAI" & passtype), _
Range("SummRowNM" & passtype), _
Range("SummRowTotPipe" & passtype), _
Range("SummRowPTAI" & passtype), _
Range("SummRowPMAI" & passtype), _
Range("SummRowPlanPAA" & passtype), _
Range("SummRowWorkPAA" & passtype), _
Range("SummRowDrillPAA" & passtype), _
Range("SummRowBaseline" & passtype))
Worksheets(ChartSheet).Activate
View 9 Replies
View Related
May 4, 2007
I have charts that needs to be placed on specific position and have specific sizes on a chartsheet. I use chartobjects(i).plotarea (top, left, width, height) for that.
Unfortunately when I set these values they still change and get antoher value, there is some scaling going on in Excel and I do not know where that comes from. I have been looking on the internet and finally I found a piece of code which works, but still not good enough, because the legend is also not good positioned.
De data for resizing the charts (ChtNew), the legends and the charttitle I get from other charts (ChtOrig). The legend.legendposition of ChtOrig does not have a value but it still have a top,left,height en width which I use.
I show you my code, the part with the for-next is taken from the internet.
With ChtNew.legend
.Top = ChtOrig.Legend.Top
.Height = ChtOrig.Legend.Height
.Left = ChtOrig.Legend.Left
.Width = ChtOrig.Legend.Width '* 1.1
.Top = ChtOrig.Legend.Top + ChtOrig.ChartTitle.Top
End With
View 9 Replies
View Related
Jan 26, 2009
I recently started keeping a new chart to track several different stocking measures. After running the data this morning, I noticed my horizontal axis had blank position holders for data over the weekend. How would I set the chart so that if there is no data in my data range, it doesn't put a place holder in the axis? Sample attached.
View 4 Replies
View Related
Dec 18, 2012
I've been successful at changing the font size for the Main title and legend using these commands:
Code:
ActiveChart.ChartTitle.Font.Size = 8
ActiveChart.Legend.Font.Size = 8
But the horizontal axis has me stumped. I recorded part of this but can't get it to work:
Code:
ActiveChart.Axes(xlValue).AxisTitle.Font.Size = 8
How can I change the typeface to Times New Roman for all three and change the font size for the Axis titles? hundreds of charts to change and not enough patience to to it manually.
View 3 Replies
View Related
Mar 11, 2014
I have a chart and a number of the data sets have a horizontal data but then some sets don't. How can I add the same horizontal data to the sets that don't?
View 1 Replies
View Related
Oct 31, 2012
I am trying to create a chart with dates from the past 6 weeks (one week at a time). The horizontal axis shows the dates from my data page correctly until I make one of the other data fields a secondary axis and then my dates change from the actual dates on the data page to 1-Jan-00, 2-Jan-00, through 6-Jan-00.
When I do the select data and look at the dats in the Horizontal Axis labels box, it shows the real dates. Why won't they show up on the chart as actual dates?
View 2 Replies
View Related
Apr 29, 2014
I am tasked to plot some client satisfaction data on a monthly basis. I want to be able to show the client satisfaction with different aspects of service delivery. Can have a chart with "Good", "Fair", and "Poor" on the vertical axis with months on the horizontal axis?
View 1 Replies
View Related
