Reverse Graph Axis Text?

Dec 17, 2013

On my graph the bottem axis shows 1-30, I'd like to change this to 30-1 as I track change over the last 30 days. I tried selecting reverse axis but it reverse's the data as well. Is it possible to change the axis text only, eg latest entry will be one and the 30 day old data will be 30.

View 2 Replies


ADVERTISEMENT

Plotting Graph With Text On X Axis

Mar 27, 2014

There is probably a really simple solution to this, but I have a column 'A' of data, with various numbers, and a column of data 'B' with letters from A to Z. However when I try and plot this on a scatter graph, the x axis uses numbers rather than letters, with data points all over the place?? I'd like the X axis to have the letters A to Z, and the data to stack up vertically when there is a few different numbers correpdoing to 1 letter. Specifically, a scatter graph

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

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

VBA Changing Y-Axis Graph?

Apr 8, 2012

I am able to change the X-Axis with:

Code:

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

How I change the Y-Axis?

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

Graph With Multiple Value Axis

May 3, 2008

how can i make a graph "like a line graph"
to have multiple value axis's?

View 9 Replies View Related

Bar Graph With Two Seperate X Axis Labels

Jan 31, 2010

Hey guys, been searching around for a while now, yet to find an answer to this.

I have 3 columns of data ......

View 9 Replies View Related

Third Axis Data - Line Graph

Apr 24, 2007

I have a line graph that contains information for the following products,

Boats , Cars & Bikes.

The chart works well but i would like to show the numbered scale of each product & i can't work out if this is possible in excel.

Currently i can only get two data showing for the axis.

I would like to show all three & just use a color to indicate which data corresponds to which product.

In my attached example: I have data for both Cars (blue) & Bikes (green) but i would like to also show data for the graph scaling for Boats (pink).

View 4 Replies View Related

Scatter Graph X Axis Grouping

Feb 28, 2008

I would like to graph the data shown below using a scatter graph. However, when I use the cart wizard it assigns numerical values to each data point and then plots the data accordingly. How can I get the scatter graph to group the assets with the same ratings together? Note, I don't want to have to assign values to assets with the same rating each time. I have attached the spreadsheet so you an see the problem.

View 5 Replies View Related

Category X Axis Labels On Scatter Graph

Apr 4, 2007

I have a set of data which I need to plot both unordered and ranked.

For the unordered (as is) data, a line graph is fine, as it gives the category labels along the x axis.

For the ordered data, i have a row with the ranking in, and then plot an xy scatter graph, so the values increase.

This obviously has the rank numbers along the x axis, not the corresponding category labels.

Is there anyway to force this? I know there are chart labelling add-ins on here, but our IT dept blocks the download.

The attched file is a very small example.

View 7 Replies View Related

Graphing With Proportional Intervals On X-axis Line Graph

Aug 14, 2014

I'm simply trying to graph my data on a line graph in Excel. see the attached.

The issue is that the spacing on the x-axis is all equivalent. I want the space between the initial and 1st month to be very small while the space between 6 month and 12 month be larger.

So at the end of the day, the line will be kind of crunched down from the beginning and goes up at the 6 month data point.

Is Excel capable of handling such simple request?

View 3 Replies View Related

How To Show Vertical Axis On Both Right And Left Side Of Graph

Nov 22, 2011

Is there a way to show the Vertical axis on both right and left side of the graph or at least on the Right hand side?

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

Format Simple Graph Y Axis Of Pivot Chart?

Nov 19, 2013

I have a pivot chart which has one Axis field (Cell Ref2) and one Sum of Values field (which is a table series of percentages calculated from formulas)

I see the graph like I'd expect, but I'm struggling to get it to show percentages rather than basic integer units on the y-axis? Usually I would imagine to just right click on the y-axis : Format Axis, and expect to see something to change the display units, but it is only for hundredths thousands etc rather than a percentage ? The units themselves in the table for that value series are in percentages so I don't see why it isnt showing the percentage units in the first place.

View 1 Replies View Related

Show Latest Date On Axis In Line Graph?

Apr 10, 2014

If I have data that shows one year back information, how do I get my chart to have the last date showing up on the axis (the date label) to always be the most current date?

View 4 Replies View Related

To Make A Line Graph With Specific Increments On Both The X And Y Axis

Oct 16, 2008

I'm trying to make a line graph with specific increments on both the x and y axis. Now, I can make specific increments on one, but have to sacrifice the other in order for me to label the lines. Im not sure how to get around this. I'll just type out what i'm trying to do and maybe you smart people can help me here.

Okay, both the x and y axis must be in increments of 8,10,12.5,16,20,25,30, and 35.

The first line should be labeled "Indicated magnification, and should have the values 8,10,12.5,16,20,25,30, and 35... the same as the x and y values, making the line a straight linear line.

The second line should say "actual m value" and have values of 10,12.5,15.5,20.5,25,31,37.5, and 44.

The third line should say "actual n value" and have values of 10,13,16,21,26,32,38.5, and 45.

View 9 Replies View Related

Excel 2010 :: How To Make Line Graph With Categories On Y-axis

Jun 26, 2014

I have been given a task to create a line graph who has 10 categories and each category has 5 different values. I need to plot a line graph, so that those 10 categories should appear on the Y-axis instead of X-axis.

I am using Excel 2010.

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

Move Mid Text In Cell To Front. Reverse

Mar 5, 2008

I am working with a column which always displays the cell contents with oldest notes by date first, then the newest note last. I would like to have the contents from a cell reversed with the newest user input by date on top which will simply when reading. Here is an example of a cell. The string always starts with (MM/DD/YYYY TT:TT:TT AM, then user name).

12/20/2007 8:27:56 AM MBARNEY Approval not required for this change request. 01/25/2008 10:27:32 AM KVELDANDA Change to Category, Type, Item, Region, Site, Department fields triggered an evaluation of whether or not the Change requires approval. Approval is not required.

View 9 Replies View Related

How To Reverse Contents In Excel Cell (Text Or A Number)

May 20, 2005

If I have the following text string in a cell "abc123.xyz" how do I reverse the contents i.e. "zyx.321cba"?

If the cell contains a numeric value e.g. 12345, then I want to know how to reverse it i.e. 54321

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

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

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

Reverse Data In A Cell / Reverse Cell Contents

Dec 18, 2009

I am trying to write a formula to reverse data in a cell. Basically I am converting a number to hex then I want to take that hex string and reverse it. So it would be something like this my original number is 400001001 my hex number would be 17D787E9 because I am only allowing it to show 8 characters. I want to reverse the 17D787E9 to read 9E787D71.

My question is: How can I reverse that cell? I have searched google and this forum and can't seem to figure it out. I am sure I could do it in VB but I don't know any VB code.

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

Change All Text Color Of Graph Using VBA?

Dec 19, 2011

I want to change the text color of a grapg using VBA (chart name, data series, x and y axis names and scales changed).

The VBA code for changing text color is:

Code:
Range("A:Z").Select
Selection.Font.ColorIndex = 1
But I don't know how to do this for a graph!

View 9 Replies View Related







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