# plot

1. ### Makro to create diagrams from a table with 89 columns

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...
2. ### Plotting proportinally in time (or date)

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: * * *...
3. ### Can you draw line but 2nd co-ords always centred?

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...
4. ### Copy and Paste Plot AND Data in which Pasted Plot References Pasted Data

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...
5. ### 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...
6. ### Dynamic Scatter Plot help

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...
7. ### Excel 2007: Not plotting first month with zero value without plotting all 12 months and changing months to Jan 12 times

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...
8. ### Operating with scatered data plots

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...
9. ### Excel 2010 - Plot lines between multiple ordered pairs

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...
10. ### Averaging binary values over a continuous, non-uniform domain.

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...
11. ### Plot Data from one sheet to another and total time

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"...
12. ### Is it possible to simplify this code with a loop? x

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 =...
13. ### Plot large number of lines while keeping them in the same style

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

### Plot graph by clicking points

Hi! Is it possible to plot a graph in Excel (using macros) by clicking points? I want to create a user-friendly way to plot a road's profile. The graph should have distance on the x-axis and height on the y-axis. For example, I want to click at (0m,2cm), then (2m,5cm), then (10m,3cm) and then...
15. ### selecting data, and plotting multiple series

I am writing a macro to create an xy-scatter plot. I have selected the range that I wish to plot. I have several series that I would like to be included in the plot (the specific number of series will vary each time and the number of points). I am having trouble with the...
16. ### Multi-Color Characters on Chart Titles on Excel 2007

On Excel 2003 I was able to set different colors to specific characters on charts titles using a VBA command like this: ActiveChart.ChartTitle.Select Selection.Characters(Start:=33, Length:=4).Font.ColorIndex = 3 This was very useful because, imagine a chart containing Temperature data...
17. ### Frequency Counter

Hello everyone thank you in advance for your help. I am currently making a file that has a list of dates. (ie 12-3-2011, 1-4-2012, 1-4-2012, 3-8-2012) I want to count the frequency of the dates and then be able to plot them on a graph. I have tried a countif function and a histogram. The...
18. ### Automated Plotting of User Selected Data

Dear all, I have a large set of data. I want the user to be able to click the first and last row of data which they wish to plot. I am getting errors on the range of the selected data. Any suggestions welcomed. Thanks, Matt VBA Code below: Sub plot_selected_date() Dim rng2 As Range...
19. ### Multiple data tables on a single graph

Hi, I am trying to plot multiple tables on the same line chart in Excel 2007. I have a list of X and Y values for Table 1, Table 2, Table 3 etc. However the size of the tables are not the same for each table. For example, Table 1 might have 200 X and Y values, Table 2 might have 175 X and Y...
20. ### Plotting the Data using vlookup or some other formula

Hi Folks, I've to plot data from one sheet onto another of the same workbook.The tab 'data' has the raw data that needs to be plotted in the tab 'Plot'.I used vlookup and conditional formating to do this till now but I found myself in soup when i had mutiple search keywords using Vlookup as it...