Changing Values Of X-axis, And Descending Order Axis(x-axis)

Feb 8, 2009

Two questions:

1) How do make values on x-axis as words? E.g. apples, oranges, etc.

2) Is it possible to have the numbers on x-axis in descending order? If I can figure out 1), I can do this as well, but it would be nice to know if it is possible to have the numbers on x-axis in descending order.

View 8 Replies


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

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 :

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


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

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

Bar Graph With Values On Left Vertical Axis And Percentages On Right Vertical Axis

Jan 19, 2012

how do you create a graph with a field such as vendors on the X-axis, but with dollar values spent on the left side of the y-axis and percentage of total dollars spent on the right side vertical axis?

View 3 Replies View Related

How To Create Engineering Graph With Two X Axis And Single Y Axis

Dec 10, 2012

I need to create a graph with a 2 x axis and a single y axis. For example:

Pressure ( PSIA) Solubility (mol %) Velocity (m/s)
200 0.024 1
300 0.036 1.2
400 0.041 1.8

I need the two x axis to be pressure and solubility and the y axis to be velocity, with the data being demonstrated by a single plot (I have only managed it with two plots which does not demonstrate solubility's relationship to pressure ).

For example at a pressure of 200 PSIA (lower x-axis) and solubility of 0.024 mol % (upper x-axis) velocity was found to be 1 m/s.

View 1 Replies View Related

Graphing 2 Distinct X Axis Variables On Same Y Axis

Mar 26, 2014

I am trying to reproduce a graph similar to this: [URL] ....

How to get the Y axis in the center and two distinct bar charts on either side.

Sample data can be found here: [URL] ....

View 1 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

Plotting Data With Two X Axis And 1 Y Axis

Dec 19, 2013

I have a data set that is a spectrum of (y)intensity vs (x)energy I was wanting to add an additional X axis at the top of the graph showing the wavelength conversion for the energy value, is that possible in excel? and if so how?

View 1 Replies View Related

Changing X Axis Value

Nov 18, 2008

I have modified the Run as Regular Macro code from this site to only changing the x axis, select different cells and I also only used object 1 instead of the name of the chart.

The problem is that when it is run which ever value is changed last, minimum or maximum, it will turn on auto and mess it all up.

View 2 Replies View Related

Add Right Axis That Look Exactly The Same As Left Axis?

Jan 29, 2014

I would like to add a vertical axis to the right of my plot that looks exactly the same as the left axis. The only way I found to do this is to add a secondary axis. However this axis is based on a data series and it does not match the left axis.

How can I make the left and right vertical axis look the same.

View 4 Replies View Related

Getting Value On Y Axis By Putting X Axis Value

Aug 15, 2011

Any way to get the values in a chart/graph by putting an specific X axis value.

E.g. There is relation between Gauge height and Flow


If I draw the curve with Flow on X-axis and Gage on Y-axis and then want to know the flow at Gage 0.53m.


By putting flow value to know Gage height.

View 7 Replies View Related

VBA Changing Y-Axis Graph?

Apr 8, 2012

I am able to change the X-Axis with:


ActiveChart.Axes(xlCategory).TicketLables.Orientation = 45

How I change the Y-Axis?

View 1 Replies View Related

Sorting Horizontal Bar Graph With Y Axis In Alphabetical Order

Feb 28, 2012

I need to sort a horizontal bar graph, with the Y Axis in alphabetical order.

View 6 Replies View Related

VBA Changing Axis Title Font Size And Typeface

Dec 18, 2012

I've been successful at changing the font size for the Main title and legend using these commands:

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:

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

Changing Default Option For Data Series So X & Y Axis

Oct 12, 2007

I'm trying to change the default option for the data series when graphing in Excel 2003 .... I am trying to create a line graph

Excel, by default, is putting static pressure on the x axis and the air flow on the y axis .... I need it to be the other way around

I have found out that:
By default, Excel plots whatever you have fewer of—rows or columns—as the data series

apparently it is possible to change this Excel default option, but I can't figure that out

in step 2 of the Chart Wizard, I have tried many different things, but can't get Excel to chart the Air Flow CFM on the x axis, and have static pressure values on the y axis

View 9 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


View 4 Replies View Related

Right Axis Derived From Values?

Feb 28, 2014

The goal of this chart is to show how sales are adding up relative to bonus levels for the month. The problem for me is in getting the right axis tick marks, labels and chart lines to match the values in Columns C and D. This need may be further complicated because the target amounts increase by a fixed percentage (11% in this sample, but it can vary).

View 4 Replies View Related

How To Plot X Axis Values From 00:00

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

Two Sets Of Values And Only One Y Axis?

Jul 6, 2012

I have to sets of values that I have graphed....number and dollar amount.

The dollar amount is in the hundreds of thousandths and the number is in the hundreds. I want to have two verticle axis. one on the left hand side for the dollar and one on the right side for the number.

View 1 Replies View Related

Lookup Values Along An X And Y Axis

Oct 27, 2006

I am not sure of the best way to ask how to do this. I am trying to efficiently lookup the X value in sheet A from the Y value in sheet B programatically as X=Y. The Values along the X and Y axis of sheet A change.

Sheet A...............................................

View 4 Replies View Related

Limiting Values Of Y-Axis In Charts?

Apr 1, 2009

Is there a way to limit the range of values on the Y-Axis on the lower end? Like I don't wish the Y-axis to begin from 0 but say 500. Is that possible?

I have a set of data values ranging from 650 - 850, but the Excel graph however looks too fine because the Y-axis begins from 0.

View 6 Replies View Related

Macro For Deciding X-axis Values?

Apr 3, 2014


Whenever I make graph with this code it takes column A values and makes a line of it on graph...What i want is that it should be always on X-axis as reference and not a line on the graph.

View 1 Replies View Related

Assign X Axis Charts Values

Sep 28, 2011

I would like to know how can I plot my x axis of a chart with the maximum and minimum value that I have in this variable. Note that my variable is no going from the lower value to the highes one, it is random. So what I did is to use the autoscale of the chart, but it is not working as I would like. Any solution?

The code that I use is:


ActiveChart.Axes(xlCategory).MinimumScaleIsAuto = True
ActiveChart.Axes(xlCategory).MaximumScaleIsAuto = True
ActiveChart.Axes(xlCategory).MajorUnitIsAuto = True
xScaleMin = ActiveChart.Axes(xlCategory).MinimumScale
xScaleMax = ActiveChart.Axes(xlCategory).MaximumScale
xScaleStep = ActiveChart.Axes(xlCategory).MajorUnit

'After I use them (xScaleMin,xScaleMax,xScaleStep) for several charts, in this way:

ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Text =VarName
ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Select
ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Font.Size = 11
ActiveChart.Axes(xlCategory).MinimumScale = xScaleMin
ActiveChart.Axes(xlCategory).MaximumScale = xScaleMax
ActiveChart.Axes(xlCategory).MajorUnit =xScaleStep

' but if my data was between 50 and 250 it is plotting between 0 and 300

View 2 Replies View Related

Dynamic X Axis Based On Values

Dec 3, 2011

I am trying to make a chart based on the following values (for example) The X axis values are week numbers, the chart X axis must stop at Week 4, the data range still contains all these cells, but the chart will only show cells with values, If i'll put a value in Week 5, the chart will auto-expand itself to include week 5 too.

Week # | Value
Week 1 | 1
Week 2 | 2
Week 3 | 3
Week 4 | 4
Week 5 |
Week 6 |

View 3 Replies View Related

Set Values To Be Shown On X Axis Instead Of Just Labels?

Mar 18, 2013

I'm trying to plot a function with specific values marked on the X axis (or at least distributed according to the said values). Namely, I have something like this:

And while it does plot the Y's as I want them to be plotted, X'es are just used as labels, which causes 0 and 100 to be equally apart as 933,9 and 944. How can I plot it, then, so that I simply select my desired Y values, their corresponding X values and get the plotted function?

View 2 Replies View Related

Setting Y-Axis Min & Max According To Worksheet Values

Jan 30, 2009

i want to set the minimum to be 20 less than the minimum value in the data, and the max to 20 more than the max value of the data.

View 9 Replies View Related

Expand X Axis Based On Cell Values

May 15, 2014

I want to create a bar chart so that the X axis scale is based the value in the reference cells. For example, a table created for running profile as follow:

The data table # of minutes2221 pace (MPH)

The chart I need to produce. The data has 4 records, but the chat needs to show bars of total number of minutes. Picture1.png How do I do it?

View 2 Replies View Related

XY-plot Diagram (text Values On X-axis)

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

Copyrights 2005-15, All rights reserved