1. R

    Outlier detection and removal from ranges

    Good day, I have a two ranges (for X and Y data) that I graph on a userform using the traditional method of graphing, exporting to image, and loading the image into a picture control. Oftentimes, the data in the Y data has a few errors in terms of outliers (X data is just dates). I'd like to...
  2. J

    Excel 365 Advanced Graph Ribbon Selection

    I took the IMA Excel Data tutorial offered By Mr. Excel. There was a discussion in the Graphing section about a ribbon tab only available in Excel Office 365 version. This ribbon tab would "suck your data into the web" (@his words) and produce graphing details not available in ordinary versions...
  3. D

    Intricate Graphing

    I was wondering if it is possible to make the graph pictured below in excel. If it is, can somebody help me figure out how to do it. Thanks in advance.
  4. M

    Graphing in Excel

    Hi All, I have data in 1 columns - 2 years worth of data. I want to colour code the graph of the data across each of the 4 quarters of the year - 1 thru 4. I am using a formula with "month" in it and "if then else", and creating 4 new columns e.g. Column 1 populates if the number of the month...
  5. A

    Excel VBA Plotting

    Hello everyone, Could someone help me with the plotting of bar and line graphs given an arrays of x and y values in VBA? I want to plot the rDateRange and rOEERange. Thank you Dim rInitialDate As Range, rFinalDate As Range, rDateRange As Range, Calculation As Worksheet With...
  6. A

    Dynamic Graphing

    Hello everyone, I am having an issue with dynamic graphing. I have followed the tutorial here : . However, in the last step, when changing the graph line equation using SERIES to accomodate the list...
  7. A

    VBA Bar Graph Code

    Hello everyone. I currently have a document with dates in column E and corresponding efficiency information in columns BC and BD. I have made a VB Program which takes an initial date, final date, shift length, and shift # (there are 2 shift #s), and should output a bar graph with from the...
  8. M

    graphing fleet mileage groups

    I have a list of trucks, 600, and I have the current total miles for all trucks how can I take that list of data and cart it to look at the distribution of trucks within various segments such as 0-50000, and 50001 - 100000, 100001 - 150000 and so on?
  9. P

    Graphing XY Plot with defined Axis

    Good Morning, For work, I am trying to graph profitability by state (could be product line, customer, etc) with Net Sales on the X axis and Operating Income on the Y. When trying to graph this in excel, it treats the selected data as two seperate series and doesn't plot based on the values...
  10. S

    Skip graphing cells that don't have values.

    Hi All, I'm not sure if this is possible but I figured I'd ask.. I've got an excel template that is set up to always graph the values over a specified range of cells. I don't want to have to edit the graph each time but I'd like it to only graph the cells that have values and skip the ones that...
  11. K

    Clustered & Stacked columns

    I have tried to follow the process from Peltier to set this up. All has worked well apart from the text for the bottom axis which I cannot seperate from the graph itself. I am using Excel2003 and XP Pro. I have stripped out the graphing part of my application and put in some figures figures...
  12. R

    Graph Question

    I'm having a heck of a time trying to figure this out but I want to make a bar graph that shows unit price and units sold over a given time. Here is an example of my data Year Qty Unit Cost 2005 10 $10,000 2006 30 $8,000 2007 50 $7,000 2008 100 $6,000 2009 250 $4,500 Basically I want two...
  13. E

    Graph/Goal Seek in Excel 2007

    One of the features I loved in 2003 version was the ability to drag/drop a point on a graph and being able to recalc that value with goal seek. That functionality seems to have been lost in 2007 version. Does anyone know of a way to drag/drop in a graph and use goal seek to change the...
  14. F

    How do I add a straight horozontal line in Column Chart?

    Greetings all, I thought this should be easy but I'm struggling. I have a basic column chart graphing number of procedures on the Y axis by dr's over a period of 3 years with each dr on X axis. For example on the Y axis I merely have numbers say 0 at the bottom, 10,000 at the top. On the X...
  15. S

    graphing two %'s as one point

    I have a problem I can't figure out. I have 2 number such as this: %gross margin %growth eggs 73% 467% How do I get excel to graph the numbers as one point? for example, i would like to have %gross margin on the x axis and % growth on the y axis...
  16. R

    Last data label with label + text

    Hi, Not sure this can be done, but if anyone can find out it is probably you. :) I have a line graph with the monthly results of a company. I have used an offset-formula for the graph, so that when the users update the dropdown menu in the workbook to the current month the line graph will...
  17. H

    Graphing Help

    I have created a graph in excel. Sheet one contains the information and sheet 2 the graph. I have the potential to have 10 data entries to be graphed; however, it will take 10 weeks to get all 10 data entries. The graph will be printed periodically within the 10 weeks. If I only have 4 data...
  18. M

    Graph: Given X, Find Y

    Hi Everyone, I have tried to recreate a graph given to me on paper by taking a few points and ploting them in excel. I now want to find a function to return the Y value for a given X in the range of the graph. I have tried using the trend function but the regression line does not come close...
  19. T

    Plot *many* XY data sets

    I have 255 sets of XY data arranged: set1_x x11 x12 x13 x14 ... x1500 set1_y y11 y12 y13 y14 ... y1500 set2_x x21 x22 x23 x24 ... x2500 set2_y y21 y22 y23 y24 ... y2500 . . . set255_x x2551 x2552 x2553 x2554 ... x255500 set255_y y2551 y2552 y2553 y2554 ... y255500 where each set of x values...
  20. F

    Charts - Using a variable to set Min/Max Axis Values

    I'm sure this is either easy or impossible. My level of skill is good with Excel, very low with VBA. I'd like to create a chart, and use a variable or name to flexibly set the minimum and maximum values for the X and/or Y axis. When I try, I get an error message that says "Your entry can not...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back