I have a graph which I would like to add Y error bars to. When I click to add the error bars, it only allows me to add horizontal bars. This is very strange because the other graph I have, it allowed me to insert vertical bars.
Basically when I click on exactly the same menu to insert error bars, on one graph it takes me directly to vertical error bars and on the other graph it only allows me horizontal bars. I have for the last twenty mins been trying to get vertical bars on the menu that gives me horizontal bars. I don't know what else to try. I googled my problem but it just says click on 'More error bars options', but this is what I do by default.
It is if Excel is 'deciding' what error bars to give me.
Can anyone help?
EDIT: This is silly, now when I click on another graph I have created, I have vertical bars as my default... Vertical bars as default on two graphs, horizontal on the other - this makes no sense.
Many thanks.
Basically when I click on exactly the same menu to insert error bars, on one graph it takes me directly to vertical error bars and on the other graph it only allows me horizontal bars. I have for the last twenty mins been trying to get vertical bars on the menu that gives me horizontal bars. I don't know what else to try. I googled my problem but it just says click on 'More error bars options', but this is what I do by default.
It is if Excel is 'deciding' what error bars to give me.
Can anyone help?
EDIT: This is silly, now when I click on another graph I have created, I have vertical bars as my default... Vertical bars as default on two graphs, horizontal on the other - this makes no sense.
Many thanks.
For Mac reate your figure, and click on it to select the whole graph, as seen below. The ^hart Layout _ menu should appear. Click on ^Error Bars _ and the ^Error Bars.
Hi, I'm trying to create a bar chart with three series of data, which have different standard errors. When I add the error bars to the chart, they're all the same height, but the correct values. When I try to click the custom button to select the series to change, the dialogue box that should come up asking to choose the series doesn't appear. Can anyone see where I've gone wrong? Thanks EggLayingData.xlsx Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar Topics
I have a pivot chart with a bunch of data series, and every time we include/exclude one of the series to see how the chart changes, all the colors change and we have to spend time re-identifying which series is which, using the legend to check the colors. Is there a way to 'lock' the colors, so that the bars stay the same colors regardless of whether other bars are included/excluded? Thanks! Keith Seemingly super simple, but I can't figure it out. When I create a bar chart, the bars are horizontal. I want the chart bars to be vertical. It tried to rotate the chart so that it is vertical, but the 'rotate' options are greyed out. How do I get those bars vertical?
I need to create a bar chart for the year. I've already have 3 bars for each of the months, a plan, an actual, and a last year. I need to be able to split out just the actual bar, so that it is a stacked bar. The other two bars need to stay and remain unstacked. Is this possible? I'm trying to separate bars inside a bar chart into separate groups. Adjust the gap applies to all bars. How will I be able to achieve what I need? Please help and thanks
I am trying to work out how to calculate the geometric mean of a series of values, some of which are negative, ie. investment returns over a series of years with some negatives. The Geomean function doesn't work because it only uses positive numbers. Any help would be greatly appreciated. I'm having a problem in a workbook with several ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color. So I removed the form control buttons and created new ActiveX command buttons. I got into the button properties and set the background colors. I added the _Click code to run the macros when the user clicked the buttons. All of the buttons were working fine. Then I saved and closed the workbook and went to lunch. Now when I open the workbook, the buttons don't work! When I click them nothing happens. They appear frozen. They don't even seem to click. No error message. Nothing. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties. I can't seem to locate the command button properties any longer. I still see the button name 'cmdButtonGetInfo' and '=EMBED('Forms.CommandButton.1',') in the name box and formula bar. The odd thing is if I create a new button it works fine until I save and close the file. When I reopen the file none of the buttons work. It's like the buttons are being disabled when I close or open the file. Any suggestions? I have imported a DBF file into Excel and have a column of dates that are missing the leading zero on single didgit months. When I try to us the custom format of mm/dd/yyyy it doesn't work (interestingly, after I select that format if I click on an individual cell it changes to the right format). Does anyone know a better way to do this? Thanks in advance! I recently moved into a new office and I am using a brand new computer on our network. When trying to edit an existing file, I'm not able to select a single cell and type. After clicking on a cell, if I move the mouse at all (even without pressing the left button) it just continues highlighting cells no matter where I move the mouse. I am also not able to click on the tool bars at all. I have to actually Ctrl-Alt_del to get out of the program. I'm sure this is something simple, but I don't know that much about this program. Any help would be greatly appreciated.
Good afternoon, Is there a way to enter a colon into a standard number to create a value that can be formatted into a 24 hour time value ? eg a time is listed as 1345 with a general number format, and I want it returned as 13:45 witha custom format of hh:mm. Other than creating a table and using a vlookup function, I am hoping there is a better way? Darren I am a very advanced Excel user so this is a new one for me. When I open any spreadsheet (new or already populated) the black box that normally frames the active cell is missing (showing which cell you have selected). Likewise when I 'select all' the sheet does not become shaded. In addition: Can not fill series Can not change cell format (specifically to show Currency or Accounting w/$ symbol) And I am sure there is much more that I have not found yet. I have not seen a single thread on this topic anywhere on the internet. Help! Is there a way to use the new conditional formats (data bars, icon sets, etc) in PowerPoint? Basically, I'd like to create a table that shows icons based on data, like in Excel? I know I could paste a pre-made Excel table as a picture, but I'd like to avoid that if possible. Thanks!
I want to create 6 numbers from 11 numbers.. lets suppose my numbers a 1,2,3,4,5,6,7,8,9,10,11 I want to generate all possibilities of the 6 numbers. But i dont want duplicate series.. I mean 1,2,3,4,5,6 and 6,5,4,3,2,1 are duplicates. ANY HELPS ARE GREATLY APPRECIATED Hello, I'm a bit of a newbie with Excel, but... I have several cells with data that contain both letters and numbers (4H, 8V, 4FH, etc.) What I want to do is remove only the text characters from these cells, and add the remaining number values together among a series of cells with this data type. If your answer involves using a macro or VB, please provide a link on how to use the formula. I've never used a macro or VB. Thanks. Hey everyone, I'm really hoping someone can help me with this... I need to plot percentages over time in a line graph in excel. I don't want to have to do a percentage equation in the spreadsheet, I just want excel to take two sets of values and display the percentage in the chart. For example, I need B1 as a percentage of B2 for week 1, C1 as a percentage of C2 for week 2, etc.... Can someone please offer a suggestion for how to do this? I would really appreciate it. Also, would it be possible to link data from other sheets in the workbook into one single chart?
I have a large spreadsheet in Excel 2007. I am converting it to a .csv file to import in to another program. I need to delete all commas from all data. When I try to replace all commas (with nothing or with another character), I get the error message 'The formula you typed contains an error.' I have tried various formats (text, general, etc.) and various file types (.xls,.xlsx, .csv) and still get the same error. I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar. I am extremely confused, can anyone help?
I have a co-worker's file that he is having trouble with. He is using Excel 2000 SP3. When copying a cell with a formula in it of '=D6+C6' and pasting it into the next cell down, it will display the same value in the cell as the calculated value from above, but has the correct formula displayed in the formula bar of '=D7+C7'. Example: A1: 50 A2: 10 B1: 60 B2: 20 A3: Formula: =A1+A2 Displays: 60 Right click A3, Copy, right click B3, paste A3 displays 60 When I click save, it will change the display value to 80. I am trying this on his workstation and mine. Mine has Office 2010, so I think there might be an issue with the file itself. Also, not just copy and paste. I can also just click the top cell after filling in the formula and then drag the bottom right of the cell downward and it will do the same of filling in the correct formula, but have the incorrect value. I know that I could get him to just click save each time before really looking at the results, but that is just a band aid to the problem. Any ideas how to fix this? I have an excel form, I want my users to be able to open the form, fill in appropriate data, then click the save button. When the button is clicked, the data in the form should be saved to a new file and then the original form should be reset (clear all values) for a new set of data entry. When the data is saved, I want the new excel sheet to be saved to a location specified within the macro so the user doesn't have any options and I want the title of the new file to be the value of one of the cells. I'm new to macros and would appreciate any help this board can offer. Thanks...
I have a set of data about with approx 7500 cells all contained in one column. The data has a series of peaks that happen, and I need to identify each peak value and place it in a cell. The peak does not occur at regular intervals but they are somewhat regular, as in within 130-230 data points. So, if one could find the first peak in the first 200 cells, identify it and store it somewhere, then look in the next 200, store it, etc. I don't know how to do that in excel. Please help Thanks Jon I have a problem sometimes. I will click on a cell to add information. The cell turns blue and then wherever I move, it highlights those to. No matter where I go on the page. If I Alt-Tab and work in another program on my computer, that excel page keeps highlighting wherever I move even in those other programs (I know this sounds confusing). When I return to excel thousands and thousands of cells are blue. The biggest problem is that the highlighting won't turn off, no matter what. I can't select anything from the tool bars, do any work on the sheet or close the program. I can close it only with the task manager but when I open it again, the cursor is still stuck in the highlighting mode and won't perform any other functions. Do you think this is a problem with my computer, the excel program? I have changed my mouse and this didn't help. Is there some shortcut to turn off this highlight feature other than restarting my computer. Which is the only current way I can get rid of it. Thanks for any advice,
I'm trying to use VBA to go to a website that requires a User Name, Password, and a Submit Button. So far I can get everything to work besides the Submit part. The code runs without errors, but doesn't actually 'hit' the submit button on the webpage. For posting, I removed my actual user name and password and and used the generic ' User Name ' and ' Password ' highlighted in blue. I highlighted another section in green that I took from a previous post hoping it would solve my problem. The link is: http://www.mrexcel.com/forum/showthr...xplorer+submit Here is the code I am using: Sub GoToWebSiteAndPlayAroundNew() Dim appIE As Object ' InternetExplorer.Application Dim URL As String Set appIE = CreateObject('InternetExplorer.Application') URL = ' https://efolio.morgankeegan.com/escripts/defaultLogon.asp?errCode=2 ' With appIE .navigate URL .Visible = True Do While .busy: DoEvents: Loop Do While .ReadyState 4: DoEvents: Loop .document.getelementbyid('fUserName').Value = ' UserName ' .document.getelementbyid('fPassword').Value = ' Password ' End With On Error Resume Next x = 0 For Each mitem In IE.document.all mitem.Value = 'x' x = x + 1 Next x = 0 For Each mitem In IE.document.all If x = 'Submit' Then mitem.Click Exit For End If Next End Sub
How to create a userform that will have button for search, edit, change, delete individual recordings. Also in case of listed results obtained records that could be printed? Thanks
Hi guys, would really appreciate anyones help with this. I have a column full of text-formatted fractions... 4/5 6/4 3/1 2/5 4/5 etc, etc.....the column is very long!! I need to convert these to actual fractions...ones I can add to equations, allowing me to multiply and add. If I highlight the column and goto 'format Cells' and change to fraction, the values still stay in the left of the cell.....its only when I manually click on each individual cell, then tick the little green tick, does the cell validate, and the value in the cell moves to the right (and is therefore a proper value).....problem is I have to keep doing this for each individual cell.....and I have 70000+ cells in this column! Any suggestions on how I could speed this up? thanks
I have a excel spreedsheet that contain external data. I would like to put a button in the excel sheet to update the sheet without doing right click and refresh. My user here are very dummies. Hi Forum, Need help to generate Series of Items in different Permuation & Combinations.. For Ex:- If there are three Items.. A B C and forming a group of 2 then the the total no of combinations would be permut(3,1) = 6... I need this to be shown as follows depending on the no of itmes and no of group no=2 in this case... Permuations & Combinations are as follows: AB AC BC CA CB BA |