A Prism project file can contain more than data, analyses and graphs. Of textbook quality, certainly far better than any other end user manual I'm familiar with. GraphPad Prism 7 A way to uninstall GraphPad Prism 7 from your system You can find on this page detailed information on how to remove GraphPad Prism 7 for Windows.
I understand how to have Excel automatically determine S.D. and add the bars to my graph, but I have a special case that requires me to 'tell' Excel what my S.D. actually is for each point on the graph, and I can't seem to find a way to do this. Any help is appreciated. Free Excel CoursesSimilar Excel TutorialsError bars in Charts in Excel How to add, manage, and remove error bars in charts in Excel. Error bars allow you to show the potential variance ... Count the Visible Rows in a Filtered List in Excel How to use the COUNT function on a filtered list of data so that hidden rows are not included in the count. To do ... Sum the Visible Rows from a Filtered List in Excel How to SUM only the visible rows from a filtered data set in Excel. To do this, we will use the SUBTOTAL() function ... Average the Visible Rows in a Filtered List in Excel Average the results from a filtered list in Excel. This method averages only the visible rows once you apply a fil ... Subscribe for Weekly TutorialsHelpful tutorials delivered to your email!Helpful Excel MacrosCreate a Column Chart with a Macro in Excel - This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang Excel Macro to Save a Specific Worksheet as a New File - This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a Macro to add a New Line to Message Box Pop-up Windows in Excel - This is a very simple Message Box, pop-up window, macro for Excel that illustrates how to put new lines, the same thi Complete Guide to Printing in Excel Macros - PrintOut Method in Excel - This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth Save the Current Worksheet as a New Excel Workbook File - This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a Similar Topics
I have a graph with various information in it. One is a line graph that tracks hours used in that department per month. The problem is that when it gets to the last month, and there is not yet data for future months, the line goes down to Zero (leavin this big diagonal line that makes the data look funny). I need this line to stop on the last month there is data for. (I do not manually enter the data, it is a formula that I do not wish to delete.) I know I can manually move the data that the line is pulling to make it stop on the last month, but I have a graph for 36 different departments and that's a pain to have to manually adjust 36 graphs each month. Is there a way to tell the line to stop if there is no data? Thanks!!
how can i find the coordinatres of the maximum point on a curve plotted in excel????
Morning all, Say I had a line graph for 4 years and I wanted it to be a solid line for the first three and a dashed line for the last one, is that possible? Many thanks for your help
This may be less of an Excel question than a general data display question, but I'll try here. I have 3 variables that I'm charting. I have one on the primary axis and it's values are in the billions. I have one on the secondary axis and it's a percentage. I need to display a 3rd who's value is in the millions. If I put it on the primary axis, you cannot see modest changes. Is there a tricky way to get all three on one graph? I know I could split on two graphs, so that's my backup plan. Thanks, Dave
We have a number of Excel users in our office who cannot copy and paste between Excel workbooks. They can copy and paste between worksheets. When you highlight the section to copy and then go to the new workbook both the paste and paste special are 'grayed out'. This is true whether you right-click the mouse, go to the edit menu, or use control keys. This occurs with any data type and the most simple workbooks. I have seen some suggestions here but none have worked for this particular problem. I have reset the menus and renamed the .xlb files and neither helps. You can open the clipboard and the paste will work, but there is no paste special option. Any help would be greatly appreciated. Thanks!
Regarding Charts in Excel: Is there a way to have the Min and Max values adjusted dynamically for the Scale of the values being displayed ?? I know that I can use named ranges to display various sections of data -- month by month, or quarter by quarter, for example. But when the value of these ranges vary greatly from section to section I end of having to manually go and adjust the Min and Max values of the chart scale. For example, if I was looking at a graph of the S&P 500's prices last November, a Min and Max range of 750 to 1200 would be fine. But if I had a dynamic range established and scrolled over to view the S&P 500's prices for this past February, I would need a Min and Max range of around 650 to 850. Is there a way to have these Min & Max values adjust automatically depending on the values being displayed ?? Thanks StanSz
Hi I am looking for a formula to remove special characters and spaces from a cell I have been using 'substitute' but this requires me to know which character I want to remove and this isn't always known I have tried looking at some macro solutions but became lost quite quickly Any help would be much appreciated 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?
Hi all - Im very familiar with how to write a macro to automatically autofilter a list based upon a Cell Value (i.e. Range =(A1)...etc.).... but what I cannot figure out how to correctly write is a way to have Excel automatically autofilter a list for any row that CONTAINS the Cell Value, instead of just the exact value. Cell Value = 'birds' Example -- I need to filter every row so that I see every row that CONTAINS 'birds' in the character-string, not just the row that = 'birds'. a) is this possible? If not, I'd like to know also so I can stop attempting to guess (-; Thanks!!! Matt
How do I get the colors to change automatically when I use a drop down list. Per say here is what I am trying to do If a certain 'word' is used from the drop down list I want the background of that cell to change its color to 'green.' And if later I change the 'word' to another from the drop down list, it will change it's color to a specified color. The drop down list that I use was created from cells that have the colors already in the 'word', but I do not know how to make the list show the colors so it puts the word & color automatically in the drop down list to the cell with the drop down (if that makes any sense). If there is a way, please spell it out simple enough for me to understand, as I don't know fully the capabilities of formulas or vba.
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
Is it possible to apply a filter to multiple sheets within the same Excel workbook, using the same filter criteria? For example, suppose you have tables of data on 3 different tabs, all having the same headings. Suppose one of the headings is 'gender'. If you apply a filter to the table on Sheet 1, to only show the rows containing the word 'female', is it possible to have the tables on Sheets 2 and 3 automatically update to only show the 'female' rows? Or would you have to manually update the filter criteria in Sheets 2 and 3? I hope this makes sense. Thank you in advance for any help.
I run a small business. I want to start keeping track of inventory using a barcode system. I know Excel 'ok', but I don't know programming.' I'd like to be able to do something very simple (for now)... For example...if I had PRODUCT / CODE / INV VALUE A - CODE A - 5 B - CODE B - 11 C - CODE C - 14 I would want to be able to click a button (or scan a code for) : ADD +1 or REMOVE -1 ...then scan the barcode on the product (A) and have it add or remove one, respectively. So, if the row for A is: A - CODE A - 5 I choose 'ADD' (with a button or scan code), then scan the barcode, and the spreadsheet automatically finds the code in the sheet, and changes the corresponding inventory value: A - CODE A - 6 Does that make sense? How might I go about doing that?
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?
Posted this on the Ozgrid forums, but haven't gotten any help yet, so I thought I'd try here too! I've been having a strange problem lately. I have a fairly lengthy macro that works perfectly most of the time. Occasionally it will run as expected but as soon as the macro ends, excel becomes unresponsive to mouse-clicks. When I click anywhere (trying to select a cell, or an excel menu item...clicking anywhere in excel) I'll get the a 'ding' system sound and nothing will happen. BUT, if I use the keyboard arrow keys, I can see that the active cell selection moves accordingly. Then it gets really strange - when I have a cell highlighted and press any key to input text, it gets duplicated. So if I press 's' it will input 'ss' into the cell, and then when I press enter it will auto-move to the next cell down, but nothing ends up getting saved into the previous cell. I don't understand what's going on at all. I can't think of anything in my macro that would have these kinds of effects. I've made sure that screenupdating is turned back on at the end of every procedure. If I go into the VBE, I can manually run procedures and they all work fine. The only way I've been able to get back to normal is by force closing excel altogether and re-opening. Any ideas? ______________________ Still having trouble, and the same thing is happening with this workbook on two different computers, so I don't think it's a hardware, or OS specific issue. When it gets locked up like this, I can still do anything in the VBE (edits cells, run macros, etc.) with no problems. If I'm in the excel window, I can click alt on the keyboard and the shortcut keys for the menu come up, but I can't go deeper than that by clicking the letter shortcuts, they do nothing. If I use the delete key to delete the contents of a cell, then it gets deleted. But if I type anything else (numbers, letters, or symbols) then it types 2 instances of the key every time, yet when I hit enter, nothing changes in the cell. I also can't really bring focus to the excel window if something else (ie. the VBE) is on top of it, clicking into the excel window just gives the little system 'ding' sound and nothing happens. If I hit the save button in the VBE (since I can't click anything in the excel window), then it seems to snap out of it and go back to normal. I tried searching for anything simmilar to this and can't find anything... Any help would be much appreciated. This is driving me nuts!
Hi All, I am trying to make excel automatically add a leading zero to values which are 5 digits long; i.e. number input is 15185, then excel automatically changes it to 015185. If I put a Customer Number Format of 0##### it works, however, a user could put any length of number into these cells, and if the number is less than 5 digits I don't want a leading zero. Is there any way of writing a small macro to sort this out. The numbers would be input into range B16:223. Many thanks, Andy
Hello. I have two huge excel files, with many rows and columns, they 'should' look the same. But I need to find out if anything has been added or removed from the second one compared to the first one. Which is the easiest way to accomplish this? Searched this forum and Google but couldn't find what i was looking for. Thanks in advance!
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 have a given length of steel bar...Example(550 feet) I have various cut lengths that I can pick from... 14'-10'.....13'- 9'.. 12'-8'........(up to 6 different lengths) I need to know the best combination of lengths to cut the long bar into to have minimal scrap left when we get to the end of the 550 feet..... Cut as many of the longest cut lengths possiable.....Cut as few of the shortest cut lengths possiable Due to the fact that I will have to convert this to a PLC application when completed, I want to find a mathmatical way to do this inside excel and not use the 'solver'....Assuming that I/we can come up with an equation to do this ..... Any and all advice/help would be appricated..... 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
Hi- I am brand new to Mr. Excel and would love some advice. I searched the boards pretty extensively but could not find what I am looking for...I apologize if this is a duplicate. I am using Excel 2007 How do you automatically add rows and update values for cells to a linked worksheet in which rows have been added? For example: Sheet 1, columns A & B are linked to Sheet 2, columns A & B. Sheet 2 has values in A1:A5 & B1:B5 and Sheet 1, since it is linked, has the same info. I want to add a row in between 3 & 4 on Sheet 2 and want Sheet 1 to automatically add the same row and update the value of the cell in column A & B. Any help is greatly appreciated! John
Sorry for the question. Normally I find answers to my excel questions by going through the help tab or by searching on Google. However, I don't even know what question to ask on this one!?! Basically I have created a spreadsheet with several columns, but I have one column that lists the shirt size (YS, YM, YL, AS, AM, AL, XL, 2X, 3X) of each person. Is there a formula that I can create that will tabulate the number of sizes (i.e. AS=2, AM=7, etc.)? In previous years I made a column for each size, and simply placed a '1' in the correct column, and had excel just add the 1's from each column. However, that takes more time and space. I was hoping to streamline it this time around. Thanks for taking the time to read this post. Any help would be appreciated! Thanks, doug
Hi Everyone, I have searched online and in help but can't seem to find the best solution... I have values like 00904BB303D6 that need to become: 00:90:4B:B3:03:D6 (the value is always 12 digits, and the : needs to appear every two digits.) Is there a formula that can easily do this for me? Your suggestions are greatly appreciated! Thanks in advance!!!!
Good afternoon! I'm working with Excel 2003 sp 3 on Windows xp. I have been banging my head trying to jar loose the formula to calculate man days where 1 equals 8 hours. I have one that was given to me by a coworker: =INT(Q3/8)+(((Q3/8)-(INT(Q3/8)))*0.8) That calculates man days from total hours. I need a formula that will total man days and return the man day answer. Example: weekending 12/25 = 16.2 which is 16 man days and 2 hours weekending 1/1 = 24.7 which is 24 man days and 7 hours Total = 41 man days and 1 hour I have also been asked if there was a way for a number to be entered into a spreadsheet and automatically put in order without a macro or 'pushing a button'. Any advice is greatly appreciated! Happy New Year! ~ Brenda ~
Hi Excel experts, I am working on a worksheet, and would like to have an entire row transferred to another worksheet based upon a certain cell's value. Having searched through the many solved threads on this site, I attempted to customize some of the code to my worksheet. Not being proficient in Macro/VBA, I failed. I figured I would ask for help, and see if anyone can provide what I am looking for. Basically, I am attempting to construct a 'work in process' file, and would like all completed work to be deleted from the work in process sheet, and transferred to a sheet that contains a running list of all work completed. Attached is an example of what I am working on. I would like Column Q (Status) to determine if a row can be moved to a sheet that contains the list of all work completed, and eliminated from the original sheet. Once Status is updated to 'Complete', it would be helpful to be able to run a macro/click a button that would perform the transfer. Can anyone assist? Thanks! |
Related Articles
- 1 Redraw a Legend on Excel
- 2 Make a Graph With Strings in Excel
- 3 Draw a Graph in MS Word
- 4 Multiply the Cells of a Column to the Result of a Formula in Another Cell in Microsoft Excel
For even the most new-to-the-program users, compiling a graph in Microsoft Excel is fairly intuitive. Excel offers a one-click option on its “Insert” menu to take data on a spreadsheet and render it in a visual aid format. By default, though, Excel’s graphs don’t include label information such as the exact numbers used to create the graph or the percentages that are represented. This doesn’t mean you have to go without; just add the labels manually with text boxes or let Excel add them for you automatically.
1.Start Microsoft Excel. Click into the first column and type a number to use for plotting on a graph.
2.Press the “Enter” key and type the next number. Continue filling the A column until the numbers for the graph are all entered.
3.Click into column B, cell one. Fill in numbers for the graph. This is optional—the number of columns and rows required for a graph are dependent on the type of graph you choose. A bar graph, for example, may use anything from a single column of numbers (for an extremely obvious and simple graph) to hundreds of columns. For a pie chart, you’ll want a minimum of two numbers so that your pie isn’t one whole circle without any pieces.
4.Highlight all of the cells you just input. Click the “Insert” tab at the top of the screen.
5.Click one of the graph options in the “Charts” section, such as “Line.” Choose one of the options from the drop-down menu, such as “Line with Markers.” Excel automatically inserts the graph, but it has no labels.
6.Review the new green “Chart Tools” tab and ribbon at the top of the screen. If you don’t see them, click the chart to enable them.
7.Click the second button under the “Chart Layouts” section of the ribbon, which adds the labels to the chart. The location of this button varies depending on the type of chart; in some cases it appears first. You may have to experiment with the buttons to get the labels. To undo, just click the blue left-pointing undo button in the top-left corner of the screen.
8.Add additional labels manually by clicking the “Insert” tab again. Click the “Text Box” button. When an upside down cross appears as the cursor, draw a text box in the area where you want to add a label. Type into the text box the text for the label. Repeat to add additional labels.
9.Click the “File” tab, then click “Save As.” Type a name for the new graph and click the “Save” button.
Tip
- These instructions illustrate how to make one type of graph in Excel, but your options include many others. Find them in the same place on the “Insert” tab and experiment with the different graphs and charts to see what best fits your need. The process of adding labels to the graphs is the same.
Resources (1)
About the Author
Fionia LeChat is a technical writer whose major skill sets include the MS Office Suite (Word, PowerPoint, Excel, Publisher), Photoshop, Paint, desktop publishing, design and graphics. LeChat has a Master of Science in technical writing, a Master of Arts in public relations and communications and a Bachelor of Arts in writing/English.
Cite this Article