Add Secondary Chart X-axis Below Primary Via Macro Code

Apr 27, 2008

In VBA, how to add a secondary x-axis in the lower portion of the chart if I already have the primary axis in the upper part?

This code

ActiveChart.HasAxis(xlCategory, xlSecondary) = True

just adds it to the upper if I have the primary at lower.

View 4 Replies


ADVERTISEMENT

Adding Reference Lines To Chart With Primary And Secondary Axis

Jan 10, 2014

I have a chart with sales data on one axis and inventory on a secondary axis. I have the average of each columns of data and want to add a reference line to each axis with it's average. I have added the averages to my data set, but it only adds the reference line to my primary axis. I actually began by manually inserting two lines to the chart (which seems asinine). They actually didn't print because they weren't actually on the chart, but rather just on the spreadsheet behind.

View 5 Replies View Related

Locking Secondary Axis To Primary?

Apr 8, 2014

I have been trying to break my new chart that combines stacked bars on the primary axis with their labels on a transparent line graph tied to the secondary axis. The secondary axis allows me to show the labels I want as categories and position them relative to the visible part of the stacked bar (waterfall style) proportionately outside of the bar. The trouble comes when my label positioning is less than or more than the primary boundaries. I can solve this manually by changing the max or min value of the secondary axis, but what I really want is for the secondary axis to be locked to the primary axis' max and min automatically.

View 2 Replies View Related

Set All Series In Chart To Secondary Axis?

Nov 21, 2012

How do I select all of the series on my chart and flip them over to the secondary axis? I can't seem to find an answer via google... Either VBA or straight Excel would be fine.

For the record, this is part of a larger question. I've been creating a chart using a couple for loops to work through a 2D array (VBA, clearly). At first I would just set each series to the second axis as it was created, but I've found that if I use collapseable groups to turn off different values...well, if I collapse the first series it all dissapears (still shows up in the legend, but the lines are gone.)

If I leave them on the primary axis I have no prolblem. So now I'm working on the theory that it's the way they are being added. So I'm looking for another way to put them on the other axis.

how do you put all series in a graph on the secondary axis all at once. Either an Excel based or VBA answer is fine (I can turn the Excel into a Macro if push comes to shove.)

View 1 Replies View Related

Chart: Secondary Axis To Start At 0 Instead Of Min Value

Jul 29, 2009

where i can fix the secondary value axis to start at 0 instead of starting from minimum value like usual?

like the min value of my value axis is -12, the secondary axis will follow suit, i. e 0% will start at -12. i want it to start at 0 instead.

View 9 Replies View Related

Secondary Axis Creates Stacked Bar Chart

Jul 11, 2007

When ever I add a secondary axis to my chart my bar chart sub type changes to a stacked bar chart. How do I keep the sub type bar chart? I have attached an example. I have tried playing with the gap and width of the bars but to no avail.

View 3 Replies View Related

Excel 2010 :: Color Chart Secondary Axis Remains Black

Nov 26, 2011

All I want to do is color the numbers on both the primary and secondary axis. Primary i want the shade of blue below. Secondary I want the shade of green below. Only the primary axis part of the code does its job. The secondary axis remains black. The code does complete without errors. Excel 2010.

sub color_axis()
ActiveChart.Axes(xlValue).TickLabels.Font.Color = RGB(38, 40, 118)
ActiveChart.Axes(xlSecondary).TickLabels.Font.Color = RGB(0, 153, 0)
end sub

View 1 Replies View Related

Replicating SQL Primary And Secondary Key Lookup

Nov 15, 2011

Is it possible to use a formula to replicate primary and secondary lookup in SQL and is it possible to retrieve data from Excel spreadsheets using SQL.

View 1 Replies View Related

Excel 2007 :: Primary Category Axis Title Rotates With Rotated Value Axis Titles

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

How To Right Justify A Secondary Y Axis

Mar 13, 2014

Is there a way to Right justify a secondary Y axis?

The primary Y axis is right justified, but the secondary is left justified.

View 8 Replies View Related

How To Add Secondary Axis For A Graph

Apr 24, 2012

I am trying to add a secondary axis for a graph but it is not displaying as it normally does, instead of the columns remaining side by side they overlap. I don't normally have any issue with this so I'm not sure what I'm doing wrong. I've attached images to show what i mean.

Before I add secondary axis

After adding secondary axis

View 1 Replies View Related

Stacked Column With Average Line On Secondary Axis?

Apr 30, 2014

I have a stacked column chart that I need to show an average on, that is on a second axis and shown as a line rather than a column.

I have tried moving it to a secondary axis but then it keeps changing the graph to show only the average.

this is just one of about 25 graphs I am having to do like this.

stacked 2 axis.xlsx

View 2 Replies View Related

ActiveX Listbox Does Not Work With VBA Code For Changing Chart Axis Scale?

Jun 5, 2014

I have some code for changing the scale of my chart axes so that when new data is inserted into the column which the chart sources from (say column B), the axis scales on my chart will automatically adjust (as the Excel algorithm sometimes leads to charts which are a bit squashed). This code works fine, and I have included it below.

I have then tried to introduce an ActiveX listbox so that when you select an item in the box, the reference number generated (1,2,3...etc) then determines which data series is inserted into column B using a vlookup function. However, when I do this, the original VBA code for automatically adjusting the chart axes no longer works.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
With ActiveSheet.ChartObjects(1).Chart

[Code].....

View 4 Replies View Related

Create Chart With Names In Vertical Axis And Values In Horizontal Axis?

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

Draw Log Chart Or Edit Axis Intervals And Starting Axis Value

Apr 20, 2007

I have some numeric data that has to be put on a log chart. but there is no option for log charts. so i converted my data to log and then drew a chart but i am unable to edit the axis intervals and starting axis value. whenever i change the value it gets back to its default value,ie 1. can anyone tell me how to draw log chart or how to edit axis intervals and starting axis value?

View 6 Replies View Related

Second Category Axis & Value Axis To Current Chart

Sep 27, 2006

how to incorporate another category and value axis to my existing chart.

1. I need to add a rank axis derived from my data column (C6-C15). This column should rank from highest to lowest and create a tie if any number is repeated. I have arranged the rank column in cells B38:L38 as they would appear. I would like this to appear on the top or bottom of the bar graphs.

2. Second I need to add the frequency of hits which = 3 derived from cell J1 This should appear on the chart were it is currently titled. This should create another bar graph colored green and labeled 3.

3. Lastly the numbers axis can remain the same as it appears on the chart or if it would be better to align as shown in cells B43:L43.

View 5 Replies View Related

Horizontal And Vertical Chart Axis As Value Axis

Jan 26, 2008

What is the best way to have both horizontal and vertical axis as value axis?

View 2 Replies View Related

Show Missing Values In Pivot Chart (line Chart) Axis?

Apr 18, 2013

How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.

View 1 Replies View Related

Basic Chart: Set A Chart Up With The Time Been On The X - Axis

Aug 1, 2007

I got a set of data which is only 2 colums collecting data problems. The output i get is a time stamp and a fault. Im looking to set a chart up with the time been on the X - axis and number of problems per hour on the Y - axis.

View 7 Replies View Related

Chart With Two Axis

May 17, 2007

I have some simple data and i want to create a horisizontal bar chart with 2 axis (X axis) the top one showing number of stocks number up to 270 and the bottom with Market Cap up to 1,200. (See attached). I set up the chart and it looks fine but it has only one axis so in order to create a second axis i right click on the blue series (no of Stocks) and go through the motions of setting up a secondary axis. However when i do that it ends up looking like the chart to the right with the Bars Cojoined (which is not what i want) I cannot seem to achieve 2 axis with separated bars

View 3 Replies View Related

How To Autoscale Chart Y Axis Using VBA

Apr 7, 2014

a_Y-Axis auto scale.zip

How to autoscale chart using VBA, so i can maximize the viewable area without using the default format axis on chart each time i paste new data to the table,

View 5 Replies View Related

Making Chart With X / Y And Z Axis?

Aug 13, 2002

I would like to make a graph with an x, y and z axis. All of the choices that excel gives me are only x,y graphs. How can I plot a 3-axis graph?

View 9 Replies View Related

VBA Chart - X Axis To Appear As Dates?

Jun 5, 2012

I have a simple piece of code that creates a chart using the the values in column A as the x-axis and the values in column E as the y-axis. The values in Column A are all dates in this format: mm.dd.yyyy. However, when I collect the x-values they always appear as numbers (1,2,3). Even if I format the axis to Dates, they appear as 1.00.1900, 1.02.1901, etc.

Here is the code (also, I would like a VBA solution but if this is with excel's chart tools, so be it).

Code:

Sub Macro2()
ActiveSheet.Shapes.addChart.Select
ActiveChart.ChartType = xlXYScatter
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(1).Name = "=""Rate of Productivity"""
ActiveChart.SeriesCollection(1).XValues = "='Sheet1'!$A$2:$A$4"
ActiveChart.SeriesCollection(1).Values = "='Sheet1'!$E$2:$E$4"
End Sub

View 4 Replies View Related

0 Value On Both X And Y Axis In Line Chart How

Jan 4, 2008

i want 0 values to start at x and y axis.
basically i want time in secs on x axis starting a 0 upto 4.4 secs

View 9 Replies View Related

Floating Bar Chart With Y Axis

Apr 16, 2008

I have a dataset that looks like this ....

View 9 Replies View Related

Column Chart With Both Value X And Y-axis

Jun 30, 2006

I am trying to create a column chart/graph with "Days Past Due" on the x-axis and "Quantity" on the y-axis. In other words, data from one column needs to make up the x-axis and data from another the y-axis where the bars will rise to meet that quantity. I was wondering if this is possible. I have not been able to find a way to make it work so far. I know there is a way to do it for a line graph through XY scatter, but I need a column chart.

View 6 Replies View Related

Force Chart Y-Axis MIN/MAX To Specified Value

Oct 4, 2006

Probably is in the wrong forum, let me ask a question to justify it being here. How can I force the y-axis min & max to be a particular number. If that isn't possible, how can I add a straight line to indicate the min & max?

View 2 Replies View Related

Dual Axis Chart

Jul 31, 2007

How can I turn this into a dual axis chart whereby it shows the number of current stores open (like it does right now) as a bar chart. But also as a line chart shows the store potential (%) - so for example, PSUN has 960 current stores and has a 96% store penetration rate.

View 9 Replies View Related

Bar Chart With Dropdown Box To Change X Axis

May 6, 2014

Please see the attached workbook.

I would like to create a bar chart which is linked to a drop down box (from data validation) that allows me to choose of the 3 sets of data to show in the x axis.

So if i choose "HALF YEAR", the bar chart will have two bars (one is "jan-jul" the other is "jul-dec") with the green section data if i choose "QUARTER YEAR", the bar chart will have four bars ("jan-mar", "apr-jun", "jul-sep", "oct-dec") with the blue section data if i choose "INDIVIDUAL MONTHS" i have twelve bars....with the red section data.

View 2 Replies View Related

Chart With X-Axis Range Selection

Feb 26, 2014

I have excel file and need to create a chart with X axis to be scalable, by selecting (from drop down menu) - start and end dates.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved