Axis Scaling Formula

Feb 5, 2007

I have the following bit of code in a module to try to force my chart to have sensible values for the y-axis.

With ActiveChart.Axes(xlValue)
.MinimumScale = ActiveSheet. Range("C10").Value
.MaximumScale = ActiveSheet.Range("C11").Value
.MinorUnitIsAuto = True
.MajorUnit = ActiveSheet.Range("C12").Value

I'm trying to devise suitable formulae to give me the min and max values for the axis to go in C10 and C11, based on my data, which, as they represent concentration figures, could have any values.

I've tried using various combinations of Round, Roundup, Rounddown, Int, Trunc, Floor, Ceiling, etc etc, but I can't devise anything that gives a "neat looking" axis.

And then of course, there's the problem getting the tick spacing right...

View 3 Replies


ADVERTISEMENT

Scaling Individual Axis On Radar Chart?

Jun 10, 2014

I'm trying to use a radar chart with six variables, they range from 1.8 to around 23; obviously this doesn't present very well on the Radar graph; how to format and scale each individual axis?

View 1 Replies View Related

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

Scaling Numbers Down

Apr 25, 2006

Does anyone know of a fast way to scale anything within a range of cells by a factor of 1000? Basically I have all my numbers calculated using simple formulas and I have $(K) right now. I need to get them scaled down to $(M) and I was hoping that instead of going through and typing in /1000 I would be able to find some trick that could do this for me?

View 3 Replies View Related

Chart Scaling With Macro

Jul 11, 2006

I have a spreadsheet with a massive amount of data in it.
I have this information displayed as a graph in the sheet "Chart2".
I want to be able to scroll my chart scale minimum and maximum to either side with buttons "Button1" and "Button2" located on that chart, and to be able to change the width of the graph by increasing or decreasing the chart scale maximum.
This may be a bit of a newbie question, but I haven't dealt with charts at all yet.

View 9 Replies View Related

Automatic Graph Scaling By Date

Dec 6, 2006

Look at the attached spreadsheet. It represents the times that the POG (Purchase Order Generator) program takes to run Could you look at producing a graph (easy enough) for the indicated data But then, could you see if you can have an input field in the graph that allows you to enter date – then the graph automatically redisplays for that day’s information only…….? And maybe automatic scaling for the graph? This is something I have been meaning to try – but don't know what to do.

For Example: Enter a date: 291106

**Then the information of what the user entered will automatically display but in a bar graph form. **How I can search for the information through excel? That will make the user easier to search than to find it manually?

View 3 Replies View Related

Dynamically Scaling Pages Based On Page Breaks?

Sep 17, 2013

Is there anyway I can make excel scale a set amount of information between page breaks fit 1 page wide 1 page tall? using a macro.

FT000010
SPAX SCREWS 1000pc TRADE PACK
Llandeilo
4
0

[Code]....

I essentially have this data repeated multiple times depending on how many products I am looking at, I would like this repeated 3 times per page, which is where the page breaks are currently being placed. When i tried to set Width 1 page the automatic page breaks would only allow two of these per page at 100% scaling.

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

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

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

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

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

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

GaugeFlow
0.30500.320.100220.3413880.275390.3813470.855280.4017081.322240.4137521.692480.4333542
.468280.4529963.431060.4823795.30220.5115577.774290.5229628.94510.56120913.535920.58917.68

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.

OR

By putting flow value to know Gage height.

View 7 Replies View Related

X-axis And Y-axis

Nov 7, 2006

I have a bunch of numbers, I need to make a graph out of these:

30
28
30
29
30
30
35
29
30
34..........

However, on the Y axis, there should be numbers 1-8, and on the X axis there should be numbers 0-40. I have to get the number on the chart, including the number of times the number is shown in that column. I have no idea how to do that, I tried hundreds of times. How do I put on the chart the number of times for example 30 shows up? I want it to look like this:

http://img452.imageshack.us/img452/2...celhelpzb0.jpg

ofcourse this is just one, I need to show for all numbers:..............

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

Lookup On 2 Axis

Jan 26, 2010

I have a table as attached. What I have is 2 tabs. Data - is the raw data which shows the date and time of each application per person and the time cut and formatted for lookups. Sheet 1 - This is a rota showing each member of staff.
Below the rota is a definition of each shift, i.e E = Early which is 8.30 to 5.00pm.

1.
At the bottom of sheet 1, I would like the total of each application for each member of staff for the time they have worked for each day.

i.e if staff member N-R worked a late (L) on the 2nd, I would like the number of application taken on the 2nd for N-R between the hours of 10.30am and 19.00.

I have tried nesting a vlookup and a hlookup function but I just cannot fathom it out. I have also tried to use coutifs().

OR

2.
On the data sheet I would like an additional column after the cut time to flag up applications taken for each member of staff during their shift. i.e if N-R takes 5 application on 22/12/2010 between 8.30 and 12.30, 3 after 10.30. I would like each individual app to flag up in its row if taken after 10.30 for this member of staff on this day.

View 2 Replies View Related

How To Use Date For X Axis

Mar 28, 2012

I am trying to use the following for my x-axis on a scatter plot. Excel is either formatting it into another type, or showing me day by day 0:00 time.

Is this an impossible mission? Below is how my data comes to me, I have no control over modifying it.

3/23/12 5:54:6.795 AM3/23/12 5:55:17.795 AM3/23/12 5:56:31.795 AM3/23/12 5:57:29.795 AM3/22/12 9:11:9.395 AM3/22/12 9:11:45.395 AM3/23/12 8:38:39.495 AM3/23/12 8:39:17.495 AM3/26/12 12:15:28.081 AM3/26/12 12:17:20.081 AM3/26/12 12:19:41.081 AM3/26/12 12:21:22.081 AM3/26/12 12:22:21.081 AM3/26/12 12:24:15.981 AM3/26/12 11:54:45.621 PM3/26/12 11:55:48.621 PM3/26/12 11:56:25.621 PM3/27/12 11:02:57.221 AM3/27/12 11:03:29.221 AM

View 3 Replies View Related

Format Y Axis With Mm:ss

Apr 3, 2012

I'm trying to chart three columns/twelve rows. The first column has Jan-11 through Dec-11. The second column has Average Speed of Answer (ASA) -- various times from 6 seconds to 3 mintutes 17 seconds. The third column has 00:01:00 (one minute) in every cell which is the ASA Standard which I was going to use to create a horizontal line.

When I chart this the Y axis has labels that are very random (I.E. 0:00, 0:43, 4:26, 2:10, 2:53 and 3:36). I would like to change it to every 30 seconds (I.E. 0:00, 0:30, 1:00, 1:30 etc.) but I can't figure out how.

View 2 Replies View Related

Manually Set Max Axis Value?

Nov 16, 2012

I have a chart that have y-axis values normally between 0-50 but sometimes i get a peak with value 400 and then my chart becomes unclear because y-axis max value then goes up to 400.

Is it possible to set a roof here so max value on y-axis is e.g. 60 and values above that is visible as 60 then in the chart.

View 1 Replies View Related

X-axis Spacing

Sep 10, 2008

I have 10 items on my x-axis. Is there a way to space item 10 further apart than the other 9?

View 9 Replies View Related

I Can't Select The X Axis

Aug 28, 2009

I have a graph I made some time ago and I got rid of the labels and tick marks on the x axis but now someone wants them back - simple you say, just select the axis and bring them back. But no matter what I do it won't let me select the axis. Does anyone know of a way round this? I am using excel 2003.

View 9 Replies View Related

Countifs On X Axis

Nov 26, 2009

I'm looking to count the following:

A B
a 1
a 1
b 0
b 1
c 0
a 1

If column A=a AND column B=1, add column B on the same axis. I can only get a function that adds all B column if A=a. The function should equal 3. Cells B1, B2 and B6 should be the only ones counted.

View 10 Replies View Related

Scale In X Axis

Apr 12, 2007

The scale on our chart in the X axis is mandating a numeric number. It is showing "39200" instead of 4/28/07. In any event, we would like to have 4/9/07 -- the last date we have data for and the last date that we have referenced on the X axis.

The chart is in the attached chart.xls and the data is in the attached chart.xls

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







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