plots

  1. A

    Remove Empty Plots on Graph

    I have this code that plots points on a graph. It works reasonable well except, it plots empty spaces that coincide with the weekends (Sat & Sun) (ex 06/07-06/10). Not sure why it does this, but I would like the chart to be seamless (Don't plot the empty spaces). Is this possible? Thanks...
  2. J

    Formula to tell if a point would fall above or below a line in a graph.

    Below is the chart. The numbers that decide where the point plots from are the PI ('T-89 & T-90'!I10) and LL ('T-89 & T-90'!I8)
  3. G

    Plotting value vs. time every minute when data is available by the second

    Hello, I have a set of data from a real time piece of equipment sampled every 15 seconds. To go along with this I calculate various averages, rolling averages, rates of changes between each sample etc. On of the fields I calculate is an average value by the minute. I.e., I have 4 15 second...
  4. A

    Create graph with multiple categories

    Hi all I am trying to create a scatter plot in excel and I am getting my rear kicked for such a simple procedure. My problem is I have a lot of data that needs to be compiled in a scatter plot and doing it manually will not be an option. My data kind of looks like this <colgroup><col><col...
  5. V

    line graph - abrupt/sharp decrease?

    Alright, so imagine there are y values - speed: 10, 0, 10, 10 and corresponding x values - time in seconds: 0, 20, 40, 50 Now, how can I show that at the 11th second it suddenly stops, then after 2 seconds continues with the speed of 40? So I want the line to go vertically downward. I tried...
  6. I

    create multiple x y charts, one for each column with the same x axis using excel-vba

    <tbody> Hi, I've been working on the problem of automating the plotting of line diagrams. But I did not yet manage to solve it yet. I would need multiple charts one for each column (from E to R) using the same column (B) for the X axis. The ultimate...
  7. A

    VBA Run Time

    Hi, My run time is exceptionally long and I'm not sure why. In fact, the graph doesn't even populate. I just get the not responding screen in excel. How can I make my code more sleek and faster? Private Sub Submit1_Click() If Not IsDate(InitialDate.Value) Then MsgBox "Please enter...
  8. E

    Update or refresh plot while VBA running

    I have a program which iterates on command. A plot on the spreadsheet is designed to show the progress of the iteration. However, the plot does not update while VBA is running. What is the command or technique to refresh the plot at an intermediate stage in the calculation? Regards, ernieL
  9. A

    Create a weekly report from a big data set

    Hi, I would like to know if there is a way I can create a graph of the week from a big sample size that automatically updates itself every day. for examplesay i have this data: <TBODY> 8/30/2012</SPAN> 224</SPAN> 25</SPAN> 9/5/2012</SPAN> 224</SPAN> 25</SPAN> 9/6/2012</SPAN> 228</SPAN>...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top