2 axis column chart

Anybody who knows how to make a column chart with 2 different valu

MartinNT's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1565
View this thread: http://www.excelforum.com/showthread.php?threadid=27190

10/24/2004 1:53:59 PM
excel.charting 18370 articles. 0 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 26

Make the chart with two data series
Right click on one of the data series in the chart; select Format Data 
Series, open the Axis tab; click Secondary axis

It needs to data series. It you have only one then you need to reproduce the 
values in another column and make a fake second series

best wishes

"MartinNT" <MartinNT.1emvxz@excelforum-nospam.com> wrote in message 
> Anybody who knows how to make a column chart with 2 different value
> axis'?
> -- 
> MartinNT
> ------------------------------------------------------------------------
> MartinNT's Profile: 
> http://www.excelforum.com/member.php?action=getinfo&userid=15652
> View this thread: http://www.excelforum.com/showthread.php?threadid=271903

bliengme5824 (3040)
10/24/2004 7:19:56 PM
Does this example help?


- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions

MartinNT wrote:

> Anybody who knows how to make a column chart with 2 different value
> axis'?

10/25/2004 2:39:51 AM

Similar Artilces:

Major help needed!!!! #2
Thanks for the post GE, I was able to find another computer with exce 97 still loaded. I opened the existing spreadheet and went through th tools options and unchecked th 1904 date option. Went back to m updated computer and the dates came across just fine. Also thanks Don, your comment will be noted. I was in a rushed an panic'd state : -- KyDean ----------------------------------------------------------------------- KyDeano's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556 View this thread: http://www.excelforum.com/showthread.php?threadid=27128 ...

Bart chart with lines showing % change between elements
I have 5 sets of data, each with a before and after amount that has been charted using a simple bar chart. Is it possible to have excel, using a line from the before element to the after element, show the % change between the two? I can easily calculate the percent change between the two, but if I graph it and set it to a line, the only way it can be seen is if I chart it on an alternate axis. Further, I just want a line from the top of the before element to the top of the after element, and a label showing the % change. Confused? Hope not :) Thanks for any help! I might be tempted to...

error 0x800ccc13 #2
I have Outlook 2000 installed on WinXP home. After installing modem software (for fax purposes) I now receive error 0x800ccc13 when performing 'send receive' in Outlook. Outlook Express now also fails with 0x800ccc0f error. I've disabled all spywatch and filtering software and tested Winsock using Netdiag and Winsock passes but there is a fail for NetBT transports test failed (I'm assuming because I removed all services other than TCP/IP.) I've reinstalled Outlook Express using the procedure from #318378 http://support.microsoft.com/default.aspx?scid=kb;en-us;318378&...

Create a column upon insertion or overwriting of data.
Hello, What should I read up on, where to look, what is the function or feature called, to learn how Excel spreadsheet be configured so that upon insertion or overwriting data in a cell, a new cell will be populated with the results that display relative difference and a percentage of change ? Peter Hi Peter, You should look at the Worksheet_Change event. If you are not familiar with macros, you may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm For information on event ...

MS Publisher #2
Does anyone know how to open an MS Publisher 2000 document with MS Publisher 97? You cannot open a Publisher 2000 document in Publisher 97. You need the same or later version of Publisher to open Publisher documents. -- Why is it that people don't realize that they will probably have a problem opening a newer file with an older program? Rarely does that ever happen. "Riobard" <morgan.riobard@sivh.ie> wrote in message news:12b801c38ceb$868aea80$a401280a@phx.gbl... > Does anyone know how to open an MS Publisher 2000 document > with MS Publisher 97? Because t...

Help ! #2
Hi, I have developed an application in VC++ where spelling of a word will be checked in Excel (English is default). I have used Automation for this. I want to use the same application for German and French languages. Could someone help me on how to select the language programmatically so that selected language's dictionary will be activated and spelling of a word will be checked in that selected language's dictionary? TIA, Gary ...

Why can't I view the gridlines of a certain column
Guys I don't know how to view the grid lines of Column J, the remaining columns are OK...I tried looking it up on the tools/options/view and unchecked and checked the view grid lines options but it still didn't work out. The borders come out fine when I'm printing, I can also view it while typing and on print preview, there's no problem with that...I just hope I can view the grid lines of column J. Hope you can help me out, its really annoying to see that its the only column with no grid lines appearing... Hi, Have you accidentally set the background colour to ...

Error adding users #2
Hello all: I am working with a new installation of MSCRM, and when I try to add a user I get the "AN error ahs occurred, please contact your system administrator" message. So I enabled tracing, and I have pasted the error details from the trace file below... Does anyone have any ideas? John. >MSCRM Application Error Report: -------------------------------------------------------------------------------------------------------- Error: Index was out of range. Must be non-negative and less than the size of the collection. >Parameter name: index Error Message: Index was ou...

Subquery for column names
I have a database table with a large amount of analytical data in it - all floats but for a timestamp column. Instead of returning the entire set, I want to be able to return specific columns based on a "system" number that is specified as a parameter (in this case it is written in as "S02" for testing purposes) and compare the provided system number with the column names within the table - which is what the subquery currently does correctly. Aside from creating a stored procedure to handle the result and reformat it into a string to then use as a parameter of a ...

RMS 2.0 Manual
I have a general question. I remember over year ago when we were buying RMS license we were receivig license+box with manual, user guide and Instalation CD. From some time whenever we order new license there is A2 cartboard "envelope" comming which have another A3 soft envelope in it and eventually this one ontains 10cm x 10cm RMS license sheet. Can someoe tell me is it just us or everybody have it this way. Before after we did training for customer he had Manual/User Guide to look back into if he forgot about something, I know that this manual is exact printout of ...

Need a stacked bar chart with each stack representing a month
Need a stacked bar chart with each section of the stack representing a month, but some of the months have a negative number. The chart moves the negative number to the bottom of the graph, when I need it to show in monthly order. Any help on this would be great! I agree that it is annowing. What I do is plot the absolute values of the data and selectively change the colors for the negative to indicate negative. "KellyT@HLI" wrote: > Need a stacked bar chart with each section of the stack representing a month, > but some of the months have a negative number. The chart...

Qty sold/Qty available #2
Any way of doing this on a top performer report? I would like to see the qty sold and qty available per item, not individual sales. THANKS! CT >-----Original Message----- >CT, > >Detailed Sales Report and add the On Hand column. (right click on the >report, Show/Hide Columns) > >-- >Jeff > >Get Secure! - www.microsoft.com/security > >===================================================== > >When responding to posts, please "Reply to Group" via >your newsreader so that others may learn and benefit >from your issue. > >=======...

Column Width #6
I completed a workbook (multiple sheets). Then did a save As with a different name for the French copy I had to make. I have now tiled them horizontally to validate the numbers are the same and in the English copy, Column A is at a width of 24, and column A in the French copy is closer to 36 to make it the same width. The columns have to be identical when printed and I have no idea how it is that the column widths are now so different and I cannot just drag the column to match the size of English one - the French started as the English file....what happened?? Very confused, Deborah ...

Button for goal seek?! #2
Hello I have the following data: 5 6 12 15 20 Total of all those added I will have to set a goal seek button so that i can put the total i want and then change the cell i want i tried using a macro but i couldnt do it... I just want to do it using a click of a button instead of going to menu>goal seek>etc etc Thanks a lot From John -- Neo1 ------------------------------------------------------------------------ Neo1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30329 View this thread: http://www.excelforum.com/showthread.php?threadid=515571 Any ...

FTP #2
Greetings. I have an MFC application working just fine using ftp with CInternetSession and CFtpConnection, and I'm using windows ftp server. this app needs to check file's size and dates where CFtpFileFind seems to works perfectly. I have some doubts: 1. this app seems to work fine with filezila ftp server... is there somethig I have to know working with other ftp servers specially servers runing on linux? I have seen that list files is not standard... 2. MFC can handle FTPS?? if not, does any one knows a good library? I'm starting to see libcurl. Any suggestions are welc...

2 cells 2 colors
Hi All, Here's my glitch: I've got 2 dropdown/combo boxes in a user form. Both offer variou color options. The 1st one colors an active cell the correct color tha is chosen. The 2nd dropdown colors the cell directly to the right or th active cell in the same manner. My code is pretty crude & not ver efficient, but it works correctly. The problem is when color 2 is no chosen. Currently, if a color isn't chosen, I can put an "X" in th cell, or color it a certain color, but what I want is to color i whatever the color of the active cell is. Any ideas? Thanks -- S...

Pivot chart or text box?
I am trying to create a form that will show a picture of a cylinder or something like that that has a specific length. There will be specific lenghts taken out of that (representing items being cut from it), or maybe just filling up that specific percentage of the cyliner. This is to optimize product and minimize waste. I would like my employees to just see the size of each thing they have to cut and a picture they can look at and show how many cuts will come out of one full part. I could use some code examples or maybe some data bases that might have some examples I could use as a referen...

Forms.dic #2
Hi, I might have missed out something. After installing MGP v8.0 SP5 on the workstation, I then I clicked on Modifier, the system created a file called forms.dic. After this, I can't open certain forms like Sales Transaction Windows, Sales Order Fulfillment, Inventory Transaction, etc. Other forms like Item Class ID, Journal Entry are fine. Anything I miss out here? TIA, Sugih Were these forms modified? Is security pointing to the modified forms? The new forms.dic will be empty and not contain these forms. Most firms either copy a complete forms.dic from a working workstation ...

Outlook 2007
WinXP Pro SP3 Outlook 2007 - Pop3 Can outlook 2007 have mail stores (PST) greater than 2 GB? I have a friend who keeps all for his business and is pushing the limit. I was told that Outlook 2007 raised the limit. Any clarification is appreciated. -- ***************** John Lenz JohnLenz@comcast.net 20Gb + if using the new, default, pst file type of Unicode which is the default in Outlook 2003 and later If however you upgraded outlook from a pre 2003 version, then it maybe that you are still using the old outlook format data file which has the size limitation. Within Outlook, select ...

matrix item in rms 2.0
When creating a matrix item in 2.0, and selecting the option to show the dimensions of the size and color with the description, I get a error message that "itemlookup code or item description exeeds the allowed length. do you wish to continue truncating the lookup code or description." However with the old version I was able to do this. Is the description field more restricted in size? Also it whould be easier to be able to enter the matrix reorder #,minimum order & case quantity when you create a matrx item, for now i have to do it with the wizard. Does anybody know ...

One Control for 2 codes
My Combo Box cbGSTOptions selects either tax or no tax but after making my selection I need to update with another control form the calculation to work Control 2 is under the line==== Can I incorporate these two code to just the Afterupdate of my Combo Box ---------------------------------------------------------------------- Option Compare Database Option Explicit Dim recInvoice_ItMdt As ADODB.Recordset Dim recInvoice As ADODB.Recordset, dblGSTContentsValue As Double, lngIntermediateID As Long Dim dblGSTOptionsValue As Double Dim bModify As Boolean Dim ynCheque As Boolean, ln...

How to colntrol location of category X axis labels on a bar chart?
How to colntrol location of category X axis labels on a bar chart? usually data have only positive values, category X axis labels are in the left side of vertical axis (see labelsOK.jpg). When values are all negative, labels are crossing bars (see labels03.jpg). Basically labels are always to the left from vertical axis (see labels01.jpg and labels02.jpg) which is not always visually appealing. Is there a way to have labels for case when data are all negative, located to the right from the axis and axis itself indented from chart border, so it will be a mirror image of labelsOK.jpg (see...

Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. #2
When I enter number "2000." I get 20.00 - yes, set decimals at 2 but earlier excel would accept change if you entered decimal with number. this is slowing down a budget prep and I'd sure like some help - online and tutorials say "enter decimal" but this is not working. what am I doing wrong? ...

macro help = extract content of specific columns accross a row
have a spreadsheet which consists of about 5125 rows and 2840 columns. I am using Excel 2007 in order to get access to the extra columns. Now I need help creating a macro to automate a very tedius and manual task. The first column in the spreadsheet is empty. What I Need =========== For every row I would like to extract the contents of certain columns accross the row and copy to the first column of the row. into the first column i would like to copy the contents of the following columns accross the row. 6C = sixth column, 9C = 9th column etc... 6C + " " + 7C + " &...

value of y axis position
Hi, all, After reversal of x axis, I moved y axis from right to left. However, value of the y axis appears inside of the chart, how can I move them outside. Many thanks. Billy Your statement is a little vague. If in Format - Axis, I use "Values in reverse order," it moves the Y axis to the right side, but the Y labels appear outside the chart, not inside. Or I can use "Value (Y) axis crosses at maximum value, " which also moves the Y axis to the right side, but the axis labels are still on the outside. Try this. With the Y axis selected (click any y axis label)...