Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Swap/Rotate Chart Axis


I am trying to chart a range of dates, for example. I have some boats that are on contract between dates a and b. I would liketo plot several boats with their contract date range. I have tried using a bar chart, but all the lines start at 0. I got it working using an Excel 2007 Stock chart, however, it is in the wrong orientation. I would like to Rotate the Chart 90 degrees, swap the axis, or find a better method all together. I cannot post the spreadsheet as its confidential.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Draw Log Chart Or Edit Axis Intervals And Starting Axis Value
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 Replies!   View Related
Second Category Axis & Value Axis To Current Chart
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 Replies!   View Related
Horizontal And Vertical Chart Axis As Value Axis
What is the best way to have both horizontal and vertical axis as value axis?

View Replies!   View Related
Rotate Chart/Graph
is it possible to rotate a graph. i need to turn my stacked cone graph upside-down so that the point is facing down and not up

View Replies!   View Related
Swap Series In Stacked Area Chart
I have an interactive chart displaying stacked area charts for 2006 and 2007
I currently have 2006 in front of 2007, but as the user chooses 1 of 20 units, it will look better to move 2007 in front of 2006

View Replies!   View Related
Basic Chart: Set A Chart Up With The Time Been On The X - Axis
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 Replies!   View Related
Chart With Two Axis
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 Replies!   View Related
Changing Values Of X-axis, And Descending Order Axis(x-axis)
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 Replies!   View Related
0 Value On Both X And Y Axis In Line Chart How
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 Replies!   View Related
Dual Axis Chart
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 Replies!   View Related
Column Chart With Both Value X And Y-axis
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 Replies!   View Related
Floating Bar Chart With Y Axis
I have a dataset that looks like this ....

View Replies!   View Related
Linking Chart Axis To Cells
I have seen alot of questions about linking max and min values of axis on charts to cell values. But what i need is the opposite. I have a graph that will automatically change its max and min values for the axis, but what i need is to be able to have a cell show what these values are, so basically the reverse of what people normally want.

View Replies!   View Related
Change X Axis Of Scatter Chart
The attached file has a scatter chart in which all of the data is properly displayed except the X axis. How can I get my X axis to reflect the data I have selected?

View Replies!   View Related
Chart Axis Date Intervals
I'm using Excel 2007 and I want to plot data vs dates. Furthermore I want the dates on the dates axis to increment by month not by a certain number of days. So something like this:

1-Jan-09
1-Feb-09
1-Mar-09
...

There's the Major/Minor Units on the Axis Options screen but I cannot type in a constant number since the number of days for each month is different.

View Replies!   View Related
Format Dates On Chart Axis
Using Excel 2007. Would like to format X-Axis values to display 1st month and 13th month as Feb 2, '08 for example. I would like the other 11 tick marks to remain. Sample attached ( Saved in 2003 format, I .xlsx was invalid file type)
4th micro chart uses F1:F13 for values for x axis

View Replies!   View Related
Force Chart Axis To Start At
to get this Break Even Analysis chart to start at zero.

I took one that looks the way I want it (on the left)
and tried to re-create it on the right....

the charting is starting at 1 and I need it to start at 0 like the one on the left does..... Not sure what needs to be changed to make the one on the right look just like the one on the left.

View Replies!   View Related
Broken Axis Column Chart
how to create a column chart with a broken y-axis? And if this is possible, is it also possible to have 2 gaps in the y-axis. I have several countries in which i gathered information about their (expected) population sizes over time (2003 - 2011). For each country i want to make a chart in which their population size is shown over time. In order to compare these countries i want these charts all having the same y-axis scale (which expresses the population size). To be able to do this i want to put some gaps in the y-axis. I think i need 2 gaps because i can divide the countries in "low population" countries (2-3 million), "moderate population" countries (7-14 million) and "high population" countries (> 30 million). I attached a sample file to make things more clear! I hope somebody knows more how to do it!

View Replies!   View Related
Creating Chart With Mutiple Axis
i have this data.

WeekFRM CURRCY Account val val2 val3 val4
42100¢BBHBANK403522
43100¢BK200 001310
44100ABBHBANK3013
45100ABK200 9043
46100CBBHBANK10106
47100EBBHBANK903420
48100EBK200 503527

How do i get this into a chart, with week along the bottom, Amount on the left. This is starting to be a pain now as i need to seperate by currency, but a pivot chart looks really realy messy with all the drop down boxes and stuff. I dont mind using drop don boxes, in fact, its going to be essential. but the pivot one look horrible.

View Replies!   View Related
Not Show #N/A On Chart X-Axis Labels
I have a chart that feeds from dynamic ranges which contain whole rows of null enteries displayed as #N/A. The charts do not plot these enteries (as it shouldn't) however it does display the category label even if it too is #N/A. Is it possible to remove the category label if all data for that row is null. ie the label is also removed from the chart.

View Replies!   View Related
Grouped Labels On Chart X-axis
I want to create grouped labels on a chart x-axis of the type created automatically when creating a pivot chart. For example: I have projects, samples and sample yields. There are multiple samples in a project so I have a sheet that looks something like this below:-

Project,Sample,Yield
2006ANG01,CTY001,1%
2006ANG01,CTY002,1.5%
2006ANG01,CTY003,1.2%
2007ANG03,CTY456,2%
2007ANG03,CTY457,1.9%

I would like to create a chart that has Project and Sample as the x-axis where the samples are all grouped into their project. Pivot charts do this nicely, but how to do it without a pivot chart? As you will see from the attached file I can get both Project and Sample on the x-axis, but the Projects are overlapping.

View Replies!   View Related
Chart - Mark Y-Axis With Values From Table
is does anyone know if there is a way of marking the y-axis in a chart with data from a table, so rather than having a fixed segmentation width have the distances between the data points marked on the Vertical to conform to a range in a spreadsheet? I know you can do that for the x-axis. Is there any way to do that for the y-axis as well?

View Replies!   View Related
Chart: Secondary Axis To Start At 0 Instead Of Min Value
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 Replies!   View Related
Format Chart Plot Series/Axis
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 Replies!   View Related
Hide Minus Values On Y-axis On A Chart
column chart displaying various pieces of data.

At the top of my worksheet I have a combo box which allows you to select a local authority name; and all relevant information in the worksheet is highlighted (using conditional formatting, extra series in charts to make relevant points highlight in red, etc).

I've added a series to the chart and changed it's type to line - then with the data labels positioned beneath the points on the line I can get conditional formatted x category labels - all outlined here: [url]

Because my x category labels are fairly long I've had to give them an orientation of -90 and make the minimum y-axis value equal to -200 to give enough room beneath the chart to fit the text in.

As I said above, the values below 0 are just there to provide space at the bottom of the chart, so my question is: is there a way to hide these negative values? I'm sure I've done it before, but can't remember how - I thought maybe a custom number format of #;[White]# would work, but it just inverted my text (white text on black background).

View Replies!   View Related
Adding A Coloured Marker On Chart Y Axis.
I have a simple Excel 2007 column chart which has names listed along the y axis for each column. Associated with each name in a small table is a colour reference. Is it possible to add a small marker (say a triangle or something) that aligns with each column?

Or possibly (or in addition) colour each column differently and in accordance with the assigned colours? I'm doing this with some vba code. but if someone can point out the general principle I should be able to work that in.

View Replies!   View Related
Offsetting Category Labels Along A Chart Axis
Has anyone ever succeeded in offsetting category labels in a chart by surpressing the first category label. I am plotting monthly financial data over several years and want to show category labels for the month ends which coincide with quarterly month ends (i.e Mar-06, Jun-06, Sep-06, Dec-06). If I select 2 tick marks between categories I get Jan-06, Apr-06, Jul-06, Oct-6) because my first month and category label is Jan-06. Is there a way to offset displaying the first category label by two tick marks and start with Mar-06 and then go every two tick marks between category labels?

View Replies!   View Related
Conditionally Hide Chart Axis Labels
Is it possible to hide some of the number labels on an axis; e.g. in on the chart below to hide the X-axis label 96? Or only start numbering from 97 while the chart displays from 96. Auto Merged Post;Well I have a solution to hiding the first value on the excel X axis values labels just using a custom number format;

[Black][>96]General;

but is there anyway of formating more than a couple of the number labels individually?

View Replies!   View Related
Chart X-Axis To Display Specific Numbers
I am trying to format my x-axis to list only the labels that have corresponding data points, but at the same time maintain appropriate number spacing. For example, My x-axis range is 0-90; however, I only want tick marks at 0, 5, 13, 40, 85.

View Replies!   View Related
Formatting X Axis On Scatter Plot Chart
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 Replies!   View Related
Zoom Or Expand Line Chart X-axis
I have an Excel chart as a separate worksheet. It has 10,000 data points. Is there a way to Zoom in on the X-axis only. I am looking to expand or zoom the X-axis to take a closer look at the individual data points. Since I have 10,000, I need a way to take a closer look at an area defined by the mouse pointer. Can this be done with VB code? I am not looking to expand or zoom the "Y" axis, this can be done with the scale values. Can this be done with a mouse drag or double click on the area of the chart I want to expand.

View Replies!   View Related
Move X-axis To Bottom Of Chart From Top
I have made a chart in Excel to show the half life of cells for a science project so it basically has days along the horizontal axis and percentage on a logarithmic vertical axis. However, the horizontal axis always appears at the top of the chart when I use a vertical log scale (if i dont use logs then its at the bottom where it should be). Is there any way i can move it to the bottom? i've tried everything i could think of under "format axis".

View Replies!   View Related
Pivot Chart : No Control Of The Axis Format
I made a pivot chart. On the X axis are days of the year. I would like the axis to give the months rather than the days, because it is easier to read. But when I select the chart's axis, I don't have acces to any "number" sheet in the "Axis format" section. I could just change the scale.

ActiveChart.Axes(xlCategory).Select
With Selection.TickLabels
.Alignment = xlCenter
. Offset = 100
.ReadingOrder = xlContext
.Orientation = 45
.NumberFormat = "[$-41D]mmmm;@" 'I added this line
End With
ActiveChart.HasPivotFields = False

View Replies!   View Related
Force Chart Y-Axis MIN/MAX To Specified Value
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 Replies!   View Related
Determine Minimum Scale Value Of Chart Axis
how to get the min value scale value off a graph when .MinimumScaleIsAuto = True?
The reason I ask is that I want to make my baseline for the graph that min number so that names from the x axis are not sitting in the middle of the graph. Incognito Auto Merged Post;I feel real bright...just playing around I found my answer...

With .Axes(xlValue)
.MinimumScaleIsAuto = True
.MaximumScaleIsAuto = True
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
.Crosses = xlCustom
.CrossesAt = .MinimumScale
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With

View Replies!   View Related
Maximum & Minimum Axis Values From Chart
how I get the maximum and minimum values of the axis from and excel chart? What I mean is I want to specify a chart, and output in the same excel worksheet the values for the maximum and minimum of the two axis.

I have tried various searches, but cannot come up with the answer, although I have a sneaky suspicion it in here somewhere.

View Replies!   View Related
Prevent Word Wrap In Chart Category Axis
I do not seem to be able to consistently control word wrapping in the Category Axis area in the series of charts I create quarterly. The individual names appearing are basically the same, but sometimes they word wrap and sometime they don't. In the attached sample, sheet C2-Location: PPO chart is just the way it needs to be - NO WORD WRAP. But if you change that chart to another location it word wraps. (To change locations, go to sheet D2 which controls sheet C2 chart, and change the location to SGO.) It appears that the less bars in the chart the greater the problem.

I have spent 2 1/2 hrs trying to get in control of this. I have changed font sizes, changed the plot area, changed the grid lines scale, changed the cell size on the originating sheet (D2), removed the check mark in Auto Scale on the Font tab, and stretched/reduced the entire chart without consistent success. What is most frustrating is that twice I have "accidently" gotten a chart to all of a sudden not word wrap but don't know why because when I try to repeat what I think I did before, it does not work!

Additionally, at times it may appear correct on the screen, but when I do Print Preview, it is word wrapped! I have searched multiple sites and googled multiple Excel solutions as well as pulled out some books but cannot find any references regarding how to control this.

View Replies!   View Related
Conditional Formatting Of Chart Based On Category Axis Value
I am trying to format the colour of a column chart based on the value of the x axis (not the y axis value). Firstly I need to know if it is possible. Secondly I would appreciate any hints / VBA code that could be useful.

View Replies!   View Related
Secondary Axis Creates Stacked Bar Chart
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 Replies!   View Related
Add Secondary Chart X-axis Below Primary Via Macro Code
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 Replies!   View Related
Asset Swap Function
Have 5 columns (A1-E1) with different bond data: (respectively)
Coupon, Maturity, Settlement, Price, Yield (asset swap is F1)

Depending on the type of swap I am performing i want the ASWAP (user-created) function to reference different values within the row.

For example: Swap 1 = settlement, maturity, coupon, price, curve
(curve is a user input single number 1-3)

Swap 2 = settlement, maturity, yield, price, curve (yield in place of coup)

Swap 3 = settlement, maturity, yield, 100, curve (100 for par redemption)

etc. I won't type out all the iterations, not necessary.

The way that I want the ASWAP to recognize which Swap# to use is by inputting a number into a cell beside the Aswap column that I can input 1, 2, 3, etc., and then recalculate to get the desired outcome. Want to keep this a static reference as well as the price at par (each owning their own single cell, not a fill down the columns because there are too many).

So assuming G1 is the Swap# input, and H1 is 100...

How do i write a formula that is capable of reading the input in G1 and outputting the proper swap calc.

My gut feeling was along the lines of nested IF's with the corresponding formula... but i won't mess around in futility on here.

Let me know if this is too confusing without me putting up an example.

View Replies!   View Related
Swap Values Of Two Cells
I want to swap values of two cells. can anyone help me on that? Eg. Cell A1
contains the value 20 & cell A2 contains the value 100. I want 100 on A1 &
20 on A2.

View Replies!   View Related
Swap Cells Across Row
I am attaching a sample sheet as a reference.

in fact the sheet could contain hundreds if not thousands of rows.

Look at column Player 1, the last 3 characters are AoS.

I want to find any rows where Player 1 has those three characters ( AoS ) and swap them with the contents of the Player 2.

BUT if that swap happens then the following swaps must occur as well:

Contents of Column "Side 1" swaps with Contents of Colum "Side 2"
Contents of Column "Player 1 Pts" swaps with Contents of Column "Player 2 Pts"

Ultimately I want this extended so that is the letters AoS appear in any of the following columns ( Player 4, Player 6, Player 8, Player 10)
the following swaps happens:

Contents of Column "Player 3" swaps with Contents of Column "Player 4"
Contents of Column "Side 3" swaps with Contents of Column "Side 4"
Contents of Column "Player 3 Pts" swaps with Contents of Column "Player 4 Pts"

Contents of Column "Player 5" swaps with Contents of Column "Player 6"
Contents of Column "Side 5" swaps with Contents of Column "Side 6"
Contents of Column "Player 5 Pts" swaps with Contents of Column "Player 6 Pts"

View Replies!   View Related
Code To Swap Rows
I would like to insert a form control (up and down arrows) into a specfied range of cells in a column - ideally the first column. When the form control up or down arrow of the assigned row is clicked it moves that row up or down essentially swapping positions with the row directly above or below. I've seen this functionality in custom excel applications but my searches for code on this topic have been fruitless.

View Replies!   View Related
Swap Ranges On A Worksheet
Right now I have 2 ranges say A and B. Range A is in a worksheet on row 7 and range B is on the same worksheet row 8. What I want to do is make it so that range B gets pasted in for range A and vice versa so that range A in now in row 8 and range B is in row 7.

View Replies!   View Related
Swap The Data Between Two Columns At A Time
Swap the data between two columns at a time. Here are multiple columns to be swaped in one worksheet and I have many worksheets to work with.


View Replies!   View Related
Rotate Image On Userform
I am rotating an image on a userform by uploading different gif images to simulate the rotation. There is an annoying screen flicker around the image when changing images that I would like to get rid of if possible. how to get rid of the flicker or a different technique I could use to rotate an image? 1st attempt - uploading different pictures

For h = 1 To Sheets("Bar Contents"). Range("B" & ItemRow) Step 1
PictureLocation = ThisWorkbook.Path & "PicturesTransparent" & Sheets("Bar Contents").Range("C" & ItemRow) _
& " " & h & ".gif"
GameUserForm.DrinkAnimation.Picture = LoadPicture(PictureLocation)
Sleep 50
DoEvents
Next h.........................

View Replies!   View Related
Rotate The Names In The Roster
Need excel formula (not a marco) to rotate the names in the roster.

View Replies!   View Related
How To Rotate The Contents Of Columnes Upside Down
How to rotate the contents of columnes upside down, I want the bottom values to be at the top and vise varsa.

View Replies!   View Related
Rotate Text On A User Form
how to rotate a label to a 45 degree angle on a user form.

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved