Move Vertical Axis To Right Side?

May 16, 2012

is it possible on a line chart to move the vertical axis to the right side? or perhaps show it on both the left and right?

View 2 Replies


ADVERTISEMENT

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

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

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

Rearrange Side-by-side Columns Into Vertical Columns?

Mar 17, 2013

i have a sheet that contains side-by-side,below two formatted colums which has continuous weeks appearance(named PE sheet). i wanna to rearrange the colums to be a single top-down colums according to continuous weeks(named sheet2.are there any easier and faster techniques?a macro probably or a function? arrange(english).xlsm

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

Move The Sheet Tabs From The Bottom Of The Screen To The Side?

Aug 5, 2008

Is there a way to move the sheet tabs from the bottom of the screen to the side?

View 6 Replies View Related

Plotting With Words On Vertical And Horizontal Axis

Apr 29, 2014

I am tasked to plot some client satisfaction data on a monthly basis. I want to be able to show the client satisfaction with different aspects of service delivery. Can have a chart with "Good", "Fair", and "Poor" on the vertical axis with months on the horizontal axis?

View 1 Replies View Related

Excel 2010 :: How To Move Comment Box To Left Side Of A Cell

Feb 23, 2014

I have an excel spread sheet and on the last column on the right hand side I have some comment boxes but when I hover over them they pop up to the right of the cell, and then they are off the screen.

Can I alter it to make the comment box pop up to the left side of the cell.

[Code] ....

Is it possible to adapt this code to get me the desired results or will it have to be a separate one.

Also i'm not sure if I have the code right because if I run the macro then open a comment box in the (M) column as in the code the comment box is the default size then if I run the macro again once I have the little red tick in the corner of the it changes to what the code says.

View 4 Replies View Related

Move Pivot Table Total To Left Hand Side

Feb 8, 2008

Need a way to switch the default positioning of pivot table row totals? I would like to left justify them insead of always having the totals on the far right side where they are often out of view to the user without scrolling. I end up having to place 2 pivot tables side by side so that I can make the totals appear first.

View 3 Replies View Related

Add Vertical Line To 2 Graphs With Scale X Axis At Same Time

Sep 16, 2012

Two graphs with different scale x-axis.

Graph No. 1 with smaller time frame, Daily.
Graph No. 2 with larger time frame, Weekly.
Objective: Add vertical line to mark the same times in both graphs.

Trouble is both graph already utilise the secondary axis. VBA is allowed.

View 6 Replies View Related

Stacked Columns Chart - Use Non-numerical Data In The Vertical Axis?

Jun 10, 2014

I would like to create a chart with stacked columns. Usually, the data on the Y-axis is some kind of numerical data, such as budget. I would like to have the Y-axis have non-numerical data (= nominal categories).

Example :
Take the following data :
category | productname
red berry
red carrot
green cabbage
green apple

The ouput format i want is a chart which shows on the horizontal axis the categories red and green, and stacks in each category the right productnames on top of eachother; preferably each productname should have a different colour and showing data labels (e.g. "1", "green","apple" could be 1 specific data label).

I don't know how to achieve this, because if you display data as "count of productnames", then automatically you get something like a block with value 2, which doesn't show the different productnames inside that block.

Can the desired chart be made with Excel somehow?

View 6 Replies View Related

Excel 2010 :: Vertical Grid Lines For Multi-level Category Axis Labels

Feb 16, 2012

I am having a problem formatting a chart in Excel 2010. My chart has multi-level category axis labels, and I would like to have a vertical grid line separating each major group of categories. In Excel 2003, I could right-click on one of the gridlines and then specify the spacing I wanted between gridlines. In Excel 2010, as soon as I indicate that I want multi-level category axis labels, I get a vertical gridline between each category and I am unable to alter the spacing. If I deselect the multi-level axis label option, I can adjust the spacing between the vertical gridlines, but the axis multi-level label functionality is lost. Is there a way to fix this problem without having to resort to using the drawing tools or text boxes to achieve the desired results.

View 3 Replies View Related

Compare Two Columns Side By Side To Highlight/change Color Of Difference

Nov 7, 2008

Is it possible to compare two columns side by side to highlight/change color of difference between the two cells

I need to compare and show the changes to the record from previous version and generate a report which will highlight the changes (Rather than just saying that record has changed It should tell what has changed)

For example if the

Column 1 (Previous Version) :The structure contains Wire, Bolt, Stmaps etc

Column 2 (Current Version) : The structure contains Wire, Bolt, Stamps etc

Data Changed: YES

In report is should show two columns side by side and in Column 2 it should highlight "Stamps"

View 9 Replies View Related

Side-By-Side Pivot Table Or Multiple Report Filters?

Dec 21, 2011

Is there a way to have separate Report Filters for each column in a pivot table?

I am trying to create a pivot table with 3 columns - 1: account code 2.current year (2011) 3. prior year (2010)

My Row Label is an account code field - each row is a different account code that sums up dollar amounts for the two financial years. The problem is that I need Columns 2 and 3 to have separate Report Filter criteria. So in Column 2 - I need the filter to weed out anything that is not 'Financial Year 2011'. In Column 3, I need the filter to weed out anything that is not 'Financial Year 2010'. Setting up a filter for one screws up the second, and vice versa.

Alternatively, how can I make two side-side-pivot tables that each have their own Report Filters?

View 1 Replies View Related

Two Sheets That Need To Have Unique Partial Matches Aligned Side By Side

Jul 31, 2009

I have two sheets that need to have unique partial matches aligned side by side. My first sheet is my database. The righter most column of this sheet contains a unique combination of letters and numbers.

My second sheet contains a single column which I export each month from our CMS and is a list of URLs. Within each of these URLs appears the unique set of letters and numbers from sheet 1 (and only appears once).

There are about thrice as many URLs in sheet 2 as there are entries in my sheet 1 database.

Ideally, I would like the URL from sheet 2 that contains the unique combination from sheet 1 to be pasted in the cell immediately to the right of the given unique combination.

However, I will settle for a list of trues and falses next to the URLs in sheet two that I can erase the falses, sort and paste next to the sorted list from sheet 1.

View 9 Replies View Related

Find And Match: Delete Any Row On The Old Side That Is Not Contained On The New Side

Jun 3, 2009

i have 2 excel worksheets. One of them contains over 20,000 rows of entries (old side) and the other contains about 900 rows of entries (new side). Both contain the same 9 column headings. I've shortened the list in my workbook example.

What i need to do is excel to delete any row on the old side that is not contained on the new side. I don't need the rows to match fully but the column A's (Doc number) are what i want it to check against. I've included a summarised version of the database and the old and new are separated by a heavy blue line. Need to be left with the same rows on either side of that blue line at the end.

View 4 Replies View Related

Conditional Formatting From Cells Side-by-side

Jan 6, 2010

I'm trying to figure out how some conditional formating and I cant get it to work.

What I want is for column H to be highlighted based on the value of column I.
So... If I2<721, then H2 will highlight green. If I2 is between 721&780, then H2 will be highlighted yellow. And if I2>780, then H2 will be red.

I know how to do it one cell at a time, but I need it to apply to the entire column based on the cell next to it.
Also, I dont have access to visual basic.

View 5 Replies View Related

Function To Swap Text From Side To Side

Mar 1, 2014

I need function that swaps text from side to side. Text at the left of "x" should be placed at the right side of the "x" and from right to left side:

6x15 -> 15x6 plaah plaah xsomething -> somethingxplaah plaah How to do this?

View 4 Replies View Related

Macro To Put Repeating Blocks Side By Side

Feb 26, 2008

I have a sheet with a number of repeating blocks copied down.

I would like a macro that when I select the first block, say range "A1:D30", the macro will cut the blocks below and put them side by side, so that I can compare them across.

i.e cut "A31:D60" and put it in "F1:I30" and so on ...

View 9 Replies View Related

Split The Spreadsheet To Show Both Side By Side

Nov 22, 2008

I have created a spreadsheet that has information about networks, subnets etc..

The top header for both companies in (CSV format) reads:
Network Namenet_addr1net_addr2net_addr3mask_lengthorg_idcidrlast_upd_dt

I basically split the spreadsheet to show both side by side.

I have this information for both networks that I am trying to compare what subnets, names, IP address etc... over-lap.

We are merging two companies into one, and I need to identify or highlight what information on both companies over-lap.

View 9 Replies View Related

Move Data From Vertical Column To Line Up Horizontally

May 20, 2008

How do I move data that is in a vertical column to line up horizontally (in separate columns, but same row)? For example, take an address:

Name
Address
City/St
Zip

How do I get it to go from that format to this format?

Name Address City/St Zip

View 9 Replies View Related

How To Create Macro To Move Multiple Horizontal Data To Vertical

Jul 23, 2008

I need to create a macro to move variable multiple horizontal data to vertical format with certain infomation on horizontal will be duplicated following that variables. It's looks like below where you can see variables data in column F, G, H and I are moved vertically and at the same time column A, B, C, D and E will be duplicated following the variables allocation. I've tried to use transpose but it too manual and now looking suitable macro to help on this function

Original DataAccountDim 3Dim 4AmountCurrencyV20228V20242V20211V202044006003300BXXX 9.4USD0.591.923.343.554006003400BXXX 88.17USD5.5118.0331.3233.314006003500BXXX 7.27USD0.451.492.582.75Process to automateAccountDim 2Dim 3Dim 4AmountCurrency400600V202283300BXXX 0.59USD400600V202283300BXXX 1.92USD400600V202283300BXXX 3.34USD400600V202423300BXXX 3.55USD400600V202423400BXXX 5.51USD400600V202423400BXXX 18.03USD400600V202113400BXXX 31.32USD400600V202113400BXXX 33.31USD400600V202113500BXXX 0.45USD400600V202043500BXXX 1.49USD400600V202043500BXXX 2.58USD400600V202043500BXXX 2.75USD

View 9 Replies View Related

Move X-axis To Bottom Of Chart From Top

Sep 7, 2006

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

How To View Two Or More Documents Side By Side

Nov 5, 2009

why a person such as myself cannot have two or more Excel Docs on the screen side by side at the same time? And if it can be done, how do you do it?

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

Side By Side Split

Apr 28, 2009

on the attached workbook i have date on the left jand side and some info from this data will be produced on the right hand side.

Can i have the worksheet so that if the user scrolls down the data on the left the info on the right is still in view?

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







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