plot

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

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

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

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

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

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

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

Hi This is my first post here, so I am anxious to get this question figured out. I have imported 2 x-y files into excel. The first is the coordinates of a set of about 50 points on an image. The second is the coordinates of the same points, but at different location (i.e. they have all moved...

I’ve encountered what to me seems to be a very strange problem. I have an Excel worksheet with the prices of the 16 stocks currently in my portfolio, charted on a daily basis – that’s 16 different charts (XY scatter) of day vs. price data. I’ve been updating this worksheet daily for several...

Hi, I was just wondering if anybody knew of a way I could format the colouring of the plot area of an xy chart on Excel 2000. I'm aware of how to change the colour of the whole plot area, however I am looking to use 3 different colours to highlight whereabouts someones score point lays -...

Hello all, I'm just starting to work with graphs so my knowledge about it is rather poor. So far I managed [with some help of others] to create a graph like the one below [without the orange bars] The graph is self-explanatory as all values are given on top. Now I'm looking for way to place...

Let's say I receive spreadsheets from a Dairy Farm, with over one hundred of cows, but I'm currently tracking milk productions of about six cows (Daisy, Kammi, Lina, Lulu, Madeleine and Shakira). I plot their daily milk production on graphs and do some further data manipulation with them. I...

I have a table with two columns. One is actual length (La), the other is given length (Lg). I want to plot a graph with '% difference in length' vs. 'given length (Lg)' without adding column for '% difference in length'. The equation for % difference = [La-Lg]/Lg Can I write a macro which...

I did some searching around I wasn't able to find a solution. This is what my data looks like: Category V1 V2 A 2.1 .98 B 1.8 .72 C 5.6 .75 D 1.1 .85 What I want is a bar going up for each category to the height of V1, and it...

Hi I have 3 columns of time series data but for one of the columns I only have values at specific points with the intervening points being zero (not blank). Is there a way to only plot the values on the chart rather than the zero's? I can cheat and do it by altering the Y-axis scale to start...