Uneven Spacing On X Axis

Jun 25, 2014

What I need to do is have the numbers on the x axis count up with a even increment. For example, 1,2,3,4,5. That part is easy and I can do that, the next part is not.

Next I need the X axis of my graph to have, what the graph I'm trying to replicate calls, a "squared scale". So the numbers need to look like what is above but be spaced in squared intervals.

It would look something like this: 1 2 3 4 5... note the spacing between each is increasing.

Below are pictures showing how the book does it by hand.

20140625_085909_zps204851fe.jpg
20140625_085922_zpsbc03f1bd.jpg

I think I could get it to look like this with a dummy series with the axis labels listed but I need to be able to have a point read off the actual values so the dummy axis wont work.

View 5 Replies


ADVERTISEMENT

How To Move Row Content With Uneven Spacing

May 13, 2013

I have a spreadsheet which contains 6000 rows where column A1 lists a name, B1 an address, C1 an amount and B2 the 4-digit zip code and place. Now I want to move the content of B2 to D1. I can't use offset because the spacing of the zipcode cell is not always the same.

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

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

Value Of I In A For Next Loop (even/uneven)

Jan 5, 2009

In my procedure I have a for ... next loop with "For i = 1 to Number"
How can I determine the value of i during this loop.

Whenever i is uneven some cell have to change color, if i is even cells remain unchanged.

I have most of the code figured out, except for this part

View 8 Replies View Related

Uneven Data To Separate

Dec 13, 2012

I want to separate data in cols A,B,C to match my results in cols D,E,F,G .

Have tried using left , mid , right functions but data is not evenly matched .

The most important parts I need is the results in cols D , E and G

Sheet1  ABCDEFG1ABCResult AResult BResult CResult D23SurvivedJonathan Riddell3SurvivedJonathan Riddell 37RacquetorCraig Grylls7RacquetorCraig Grylls 42KodemaOpie Bosson2KodemaOpie Bosson 56-Clutha Lad-Shane Dye(2.5L),  6Clutha LadShane Dye2.568-Viceroy-Johnathon Parkes(3L),  8ViceroyJohnathon Parkes3711-Omana-Rory Hutchings (a)(5L),  11OmanaRory Hutchings589-Sunbeam-Matthew Cameron(6L),  9SunbeamMatthew Cameron6912-Zulou-Kelly Myers(7.8L),  12ZulouKelly Myers7.8105-The Sheriff-Hayden Tinsley(12.6L),  5The SheriffHayden Tinsley12.61110-Inazuma-Bridget Grylls (a3)(12.9L).  10InazumaBridget Grylls 12.9

View 6 Replies View Related

Divide Uneven Data Into Columns

Oct 10, 2009

I would normally sort out using Text to Columns, but I can't in this case as the remaining elements can vary.

I have a list of names with Forename and Surname and then the elements after that vary.

Names are written in one cell under a single column like so:

John Smith 13/04/2000
James Smith 123 123 1233
Jane Smith 07122 12345
Another Smith AB99 9CD

All I want to do is end up with 3 columns of data,
Forname | Surname | Other

Is it possible to use a formula to make the breaks into each column at the first 2 spaces only, therefore the contents after the second space would just end up in one cell?

View 9 Replies View Related

Summing Uneven Blocks Of Rows

Apr 21, 2006

I am trying to Sum "uneven blocks of rows" using the Sum Function.This works OK for the 1st.Block,but then the selection of cells moves down the same number of rows as the 1st Block.

I am attaching a sample file which best explains what I am trying to achieve.

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

Payback & Discounted Formulas For Uneven Cash Flows

Nov 7, 2006

formula in excel to calculate payback and discounted payback periods with uneven cash flows.

EX.
Yr CF
0 ($2,000)
1 160
2 200
3 350
4 395
5 432
6 440
7 442
8 444

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

Spacing With VBA

Feb 20, 2009

I have the below code that I would like for the data to fall in the exact same space underneath their proper headings. I cant create an html shot for specific reasons and so I am stuck with creating the table in this manner. Does anyone know how to on a single row to accomplish placing date so it looks like a table

10 spaces
20 spaces
30 spaces

that way the number will always fall on space number 10, 20 and 30 on same row

strbody = "Please find attached the daily position report and Profit/Loss report for COB " & FileDate & Application.Rept(Chr(13), 10) _
& "SPREAD " & " UTILIZATION" & " FLAT " & " UTILIZATION" & " OPTION " & " UTILIZATION"

View 9 Replies View Related

Double Spacing

Nov 16, 2006

I have a list with fractions such as 25 1/4, 33 5/16, 20 15/16, etc. i have them formatted as FRACTIONS 2 DIGITS 21/25. Manny of those have double spacing ex: 25 1/2, So i am wondering if theres a way to take the extra spacing off the ones that have double.

View 10 Replies View Related

Spacing Out Data

Dec 28, 2007

I have alot of data with data and time in one column, and temperature in another. All my data is bunched together, i have temperature measurements every 3 minutes, 24 hours a day, for about a month... and then after that, i have temperature measurement 10 minutes a day, 24 hours a day for several months

I want to group my data by hour, so for my 3 minute measurements, 20 values make up one hour. And for my 10 minute measurements, 6 values make up one hour. I want to know if there is a way to space out my data so that it groups it/ spaces it out. So for the 3 minute values, it would list 20, then put say 3 blank rows, then 20 more values, then 3 blank rows etc.... and for the 10 minute values, it would be 6 values, then 3 blank rows, 6 values, then 3 blank rows etc...

View 9 Replies View Related

Extra Spacing

Oct 31, 2008

In the below example each of the items listed in Row A have an extra space before the word, is there an easy way of taking that space out i've tried text to columns, paste special. Not sure what else can be done ...

View 9 Replies View Related

Spreadsheet Row Spacing

Jan 16, 2009

Spreadsheet

aaa hhh
111 222
ww lllmm

between here there are about 50 rows

zzz 222

I need code that would reduce the spacing too about 10 rows between the "ww" in column A and the zzz in column A.

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

Spacing Between Missing Sequential Dates?

Feb 12, 2014

how to leaved blank cells for missing dates in a series of sequential dates. For example, If my series is (in (m/d/y) format):

1/10/1999
1/12/1999
1/13/1999
1/14/1999
1/17/1999
1/18/1999

But I want it to be:

1/10/1999
(blank cell)
1/12/1999
1/13/1999
1/14/1999
(blank cell)
(blank cell)
1/17/1999
1/18/1999

How do I do this?

View 1 Replies View Related

Adding Numbers Beween Spacing

Oct 25, 2009

I got a number, OK lets make it every even "5","10", "15" est and i add another one beside it to be added 0.01 every "5" times, so ok i'll make it a bit better some how,

(A1)
lv 1
=1
lv 2
=2
lv 3
=3
lv 4
=4
lv 5---(A2)----(A3)
=5 + 0.01 = 5.01.............

um I had one idea that did and one that did not work, 1. to do it manually or 2. (that did not work) us "=IF function"

View 2 Replies View Related

Spacing Error With Email Macro

Dec 19, 2009

The email macro I set up didn't work when I referenced the sendto from a cell in sheet 2; I changed it to reference an email address on sheet 1 and it worked with spacing errors. I need to fix the spacing errors, and I need to be able to pull the email from sheet 2. Code referencing sheet 2:

View 3 Replies View Related

Column Of Data Spacing - Each Value Separated By Two Spaces

Jan 31, 2013

I have a column of data. I would like to space this out so that each value is separated by two spaces.

E.g.

1
2
3

-->

1


2


3

I can do this manually (by inserting two cells), but I wondered if there is a way to do this automatically?

(I have a column organised with the spaces immediately to the left of the column I want to change.)

View 2 Replies View Related

CONCATENATE Spacing Issue Due To String Lengths

Oct 17, 2008

if you look in Column G you will notice the number on the right side of the column is indented one space too many (for any number that is 6 long in column A).

Is there any way to do an IF C=6 and then have it remove a space from before the number in Column G to have it line up?

View 4 Replies View Related

Spacing Multiple Variable Paragraphs In A Merged Cell

Jun 19, 2009

I am using excel as a base for formatting reports, and collating logical paragraphs, which I want to display in one massive merged cell on another worksheet.

The paragraphs are different for each report, and I do not wish to manually enter them in each time. I also want them to display as seperate paragraphs on the page, but in the same cell.

To throw a spanner in the works, the paragraphs are all of indeterminate length, otherwise, I could use different cells. If I combine them in the massive merged cell by using =cell1&cell2&cell3 then they will just appear merged as one whole huge paragraph. I want them to appear as separate paragraphs in the same big cell.

View 4 Replies View Related

How To Convert Excel Data To Notepad With Desired Spacing

Sep 6, 2012

If my file is like so

A1 B1 C1 D1 E1
A2 B2 C2 D2 E2
A3 B3 C3 D3 E3

i NEED THE OUTPUT IN NOTEPAD

A1B1 C1 D2 E1
A2 B2 C2 D3E2

The spacing varies from row to row

if i am saveing as notepad file....in macro how can i give the spacing properties give an example macro and i will customize it according to my need

View 2 Replies View Related

Copy Column Information On One Sheet And Post To A Row With Spacing

Feb 28, 2013

I have been able to produce a column that gives me key date information. I might have many empty cells in that column before it hits another date. I need to get this data over to another sheet and place it in a row.

I am trying to get it to look like this:

B2(value), C2(value),D2(blank),E2(Value),F2(Value),G2(blank) etc depending on how many more elements are found in the sheet.

I am able to find topics that allow me to copy a range of data but not one that will allow me to copy a range then skip a cell.

View 4 Replies View Related







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