plot

Hello, I need to plot on the same graph 2 time series (format is: yyyy-mm-dd hh:mm:ss) that have different dates. These time series are coming from a measurement equipment in 2 separate locations and the time records are in the same 24 hours period (00:00 to 23:59), but different time stamps...

Hi everyone, I have a summary-type worksheet which has a macro that searches through a much larger sheet and picks out the data that matches certain criteria. The macro spits out the date of the data and the values, next to each other, in cells E4:F4 downwards. This data also has a related...

I am currently working on my dissertation and have hit a wall. I have collected data every half an hour for 4 hours and plotted this on a line graph, however i also have data for 20 hours and 24 hours from the starting point which i cannot plot as i can't seem to create a "time gap" ? any help...

Hello, How are you doing? I got an internship during the summer and one of the tasks that I had was to plot some data in Scatter / Bubble Chart, however, I still struggling with it. Just to give a short background about the data: The data were collected in a small-scale fisheries community...

Hi there, I'm currently trying to plot two different data sets on the same line graph. The x-axis is time for both, however, the time is spaced at different intervals for each. (i.e. one records a point every 15 seconds, and the other records a point every 20 sec). My attempt at combining...

Dear everyone, I'm happy to find this forum, this is my first posting. (1) I would like to calculate the slope from multiple sets of data. Since the curves are rather complex, I'd like to be able to easily define the start and end of the "linear region" for which the slopes will be calculated...

Hello, I am looking to see if it is possible to take a value representing hours/min and break it up into 15 min interval. From here, add each 15 min interval to the corresponding section (and continue to tally if there are multiples for that section). Ex. 1) Start = 19:00 End = 22:00...

Dear All I have a table with data from a wastewater treatment plant. The table contains 89 columns. Column A is the day/date. The rest of the columns are measurements parameters from Column B till Column CH. I would like to create a makro which create an x-y dot plot with X-axis always Column...

In Excel How to plot (non dimensional) timed events (times or dates) along a horizon axis shown in proper proportion in time along the axis. DATA (simplified): One event occurs at: 2hrs 7hrs 10hrs Display: * * *...

Hi all I'm trying to figure out line drawing, I don't really mind how it's done, eg: grid making, graph plotting, but I can't get it done a specific way. The data is simple, it's 2 sets of xy co-ords (of your choice, but it needs to change when the co-ords move). What I need is for the 2nd xy...

Excel Gurus- I am using excel 2013 and have run into a problem I can't seem to find a solution to after some fairly extensive searching. My problem is that I have an elaborate data table with 3 plots referencing the data and I want to be able to copy and paste the data table and plots on the...

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...

Hello! I am trying to build a dynamic scatter block for reaches in Rivers The basic set of the data is as fallows: River : Reach : X : Y : Bear 1 0 156 Bear 2 10 158 Bear 3 20 162 Bear 4 30...

Having a problem with Excel 2007. Our fiscal year starts in Oct. I want to show all 12 months in the horizontal axis and only plot one dot at zero for Oct since we did not complete any projects for the month. Instead, it will be blank for all 12 months or will plot zero for all 12 months and...

Hello: I want to operate with two scattered sets of data. Allow me the example. I have two series of scattered X,Y data, such as: X Y -first series 4243 0,655 8485 1,000 12728 0,974 X Y -second series 4393 0,637 8787 1,000 13180 0,887 I can plot this two series, but...

I've got multiple ordered pairs and would like to plot them on a scatter plot and draw a pairing line between each ordered pair. Series 1; Series 2 X1, Y1; A1, B1 X2, Y2; A2, B2 X3, Y3; A3, B3 X4, Y4; A4, B4 Basically all 8 points would be plotted and I'd like a line between X1, Y1 and A1...

I have a very large dataset (~5000 points in a 2D array) which I need to plot and fit a linear trendline to. There are 90 subjects each of which has a daily binary event checked over its lifespan. eg: Day: 1 2 3 4 5 6 7 8 9 10 subj 1 0 1 0...

Hello Gurus. I am a newbie to VBA and I am in need to a macro that will fetch data from a sheet to another. Here is my input sheet: and here is my output sheet: Notes: Total Request = Sum up all requests (Closed/Completed/Resolved, Open, OnHold, Discontinued) EXCEPT for "IN PROGRESS"...

Hiya, I have some code that I think can be simlified, but I'm not sure how... Sub graph() Sheets("New QC").Select Dim i As Variant Dim rrange1 As Range Dim rrange2 As Range Dim rcol1 As Range Dim rcol2 As Range Set rrange1 = Range(("e8"), ("s8")) rrange1.Select With Selection Set rrange1 =...

Hello Everyone. Could you please help me with one question, because I am already struggling for a few hours. I want to plot large number of lines, which consist of two dots each, where each dot has (x,y) coordinates. I also want them to be plotted in exact the same style (e.g. color, marks and...