How can I construct a polar plot in excel 2007, I would like to plot the following:
Gain (modulus) č° (argument) 1.688 -35.94 1.43 -86.4 1.125 -130.6 0.95 -156.76 0.747 -191.86 0.607 -223.24
This seems so simple but i looked everywhere and i cannot find the vba script to add a 3 point solid black line border around the chart and plot area of my graphs. The record macro option does not record this.
View 3 Replies View RelatedWe have a lot of charts we want to create in Excel 2007. We have templates created that seem to work. (But also sometime seem to not.)
After the charts are created that are placed in their own chart pages/sheets. The problem I'm having is that the x axis title doesn't seem to be centered horizontally wrt the x axis of the plot area. (It does look centered wrt the chart area.)
Some code or an algorithm to control he placement of the x axis title and maybe center it?
construct a SUM formula. Have a problem with this macro:
View 5 Replies View RelatedMy question is about the If-Else Construct.
I often write If-Else statements that require an action be taken only if something is true. If that something is false, no action is to be taken.
My question is, how do you code "no action".
The following is what i usually
I've got a formula in my spreadsheet that is quite lengthy. I could use an array formula to replace this formula...but I don't know how to construct it. Below is an example of my current formula:
View 4 Replies View RelatedI want to construct a calendar in 7 columns; all Mondays of the year to be in the first column headed "Monday", all Tuesdays of the year in the second column headed "Tuesday" and so on till the last column headed "Friday" containing all Fridays [ignoring the month titles].
I use the applicaiton timer but it said time is 5 so what's the problems? Below i want to change to case construct.
Sub GreetMe()
If Time < 0.5 Then
MsgBox "Good morning!" & " It’s now " & Time, , “The Time”
ElseIf Time >= 0.5 And Time < 0.75 Then
MsgBox "Good afternoon!" & " It’s now " & Time, , “The Time”
Else
MsgBox "Good evening!" & " It’s now " & Time, , “The Time”
End If
End Sub
this is what i did so far but still having problems with it with case construct
Sub GreetMe()
Dim morning As Integer
Dim afternoon As String
Dim goodevening As Integer
Select Case morning
Case Application.AutoRecover.Time < 0.5.......................
How do you write an If then statement using a range of cells? I want to construct a logic test using the range of cells A7:A19. I want the logic test to see if the any of the values =1. If the test is true then I want it to display the value in B7:19 (which ever cell corrulates to the cell in column A that has the value of 1) and display the number in the B column.
View 6 Replies View RelatedIn the attached sheet I have data in column F and G which I am plotting using the following
Sub evmplot()
Dim i As Integer
ThisWorkbook.Worksheets("sheet1").Activate
ActiveSheet.ChartObjects("EVM").Activate
ActiveChart.ChartArea.Select
For i = 1 To 15
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(i).XValues = "=sheet1!R[" & 5 + (i - 1) * 13 & "]C6:R[" & 17 + (i - 1) * 13 & "]C6"
ActiveChart.SeriesCollection(i).Values = "=sheet1!R[" & 5 + (i - 1) * 13 & "]C7:R[" & 17 + (i - 1) * 13 & "]C7"
Next i
End Sub
when I =1 , the sereis should be from R5c6:R17C6. But the first series in the plot is from R6C6:R18c6. Same is the case with other series also.
This may sound like a dumb question, but hang with me. I have two series in an xy plot. One is a line (withOUT markers) and one series is just markers (no line).
The line without markers is created in a way such that it forms a box and whiskers plot. The other series, are trial values that go into the box and whiskers.
I have desperately tried to get the second series (just points) to plot BEHIND the first series (line, no markers). Changing the series order does not work unless both series have lines. I have tried this in a variety of ways (including writing a macro which draws the markers first, and then the lines), but that doesn't work either!
How to plot a step graph?
I have attached a drawing by illustrating the graph that I wish to plot.
Attached Image : jpg Capture.JPG‎
I am planning on creating a map of a badminton court. I am hoping to record each hit of the shuttlecock with a dot on the map. Of course I want this to be inputted by data rather than manually inserting a circle shape and placing it in the correct location each time.
is there any way to do this in excel?
I have a pareto for a manufacturing facility that has a list of nonconformists and their occurrences in columns K and L. My issue is since it is a running total for the year at certain times the values are 0 for the number of occurrences. This calculates fine, but the graph is very large and the failures are all located on one side instead of being evenly distributed. I am trying to get it to only plot for what has occurred and not have a bunch of blank values. To make it a little more complex I'm trying to avoid macros.. I can get them to show up blank just can't get the bar graph to resize itself to fill the chart.
View 3 Replies View RelatedI would like to make a histogram using excel. I have successfully made the bins and frequency functions. Once I want to add the x values, I get an error. There are many examples online, but I can't get it to work.
[Code] .....
I have data that starts from say, 17:50 hours. However, I would like the chart to start from 00:00 to 00:00 so it is a full 24-hour period. So up to 00:00 to 17:50 hours, it would be blank then the data will be plotted from 17:50. How do I do this? If I select the existing data from 17:50 and ask Excel to create a chart, the x axis starts from 17:50 (not 00:00).
View 4 Replies View RelatedOn Histogram, is it possible to plot Bin averages?
In my data there are two columns, 1) File Size 2) Months and then I have created Bin(months) like 0,6,12,18,24
I want to plot average file size in those Bins. For example I would like to plot what was the average file size in past 6 months, past 6-12 months so on.
I have a column, call it column1, with thousands of numbers in it.
What I would like to do is get the min of this range, get the max of this range, and plot in a new column all numbers from the min to the max.
For Example
Column1
1
4
9
3
4
4
5
9
2
2
1 is the min, and 9 is the max
I want a new column, say columnNEW
1
2
3
4
5
6
7
8
9
Any clever way of doing this in VBA?
I have an Excel file with a sheet that has the following columns: Name, Activity, Start Date,
End Date. What I would like to do: I would like to create summary sheet with a calendar-like
matrix, with the names as rows, and dates as columns. I would then like to plot the activity in
the corresponding dates (based on the start and end date). Note: If there are schedule
conflicts, the conflict should show up in another row
- Is this even possible to do in Excel?
Source:
Name Activity StartDate EndDate
PersonA Vacation Jan1 Jan3
PersonA Office Jan4 Jan5
PersonA Field Jan6 Jan7
PersonB Vacation Jan1 Jan3
PersonB Field Jan4 Jan7
PersonB Office Jan5 Jan5
Summary:
Name Jan1 Jan2 Jan3 Jan4 Jan5 Jan6 Jan7
PersonA Vacation Vacation Vacation Office Office Field Field
PersonB Vacation Vacation Vacation Field Field Field Field
PersonB Office
on a macro or vb code that can search a date and shows everything related to the date? My problem is when i select a certain week for example first week of july. I need a macro of VB code that can find all the dates (or days) in an array of dates and data, which are arranged randomly, that falls in that week and copy them to another worksheet. I have attached the file with this message.
View 9 Replies View RelatedI have some weekly data that I need to produce a graph from (100% Stacked Column). Each time I create the graph using the dates as the x axis i only get a thin line which looks like it represents one day, the other space looks like it is for the other 6 days of the week. I know that you could add an apostrophe to the beginning of the date but this is to be an automated report.
View 9 Replies View RelatedI have a set of data which indicates readings taken at different dates/times at varying intervals.
I want to create a chart where time is the X-axis but the usual charting feature would spread the data points at regular intervals. I want the data is spread out across the X-axis according to the actual timings.
I have a sample data in the file attached to this posting. There I showed the type of chart I want to see (which I achieved only by modifying the original set, Table 1. The modified set of data is in Table 2)
how to achieve this with the original table of data, Table 1.
I am trying to figure out the best way to plot this data -- For each region, I want to plot December 2006 snowfall against December 2007 snowfall. So starting on row 12 to row 41 (in the attached file). First challenge: the dates are not aligned because it is using the retail calendar where 12/3/2006 is compared against 12/2/2007. How can I plot the snow depth for the Northeast for example? I can't just use a dual axis chart because there are also dual dates...
View 3 Replies View RelatedI got the following table and it generates a random number either 1 or 0 (win or loss)
trade win/loss Account value
0 10,000
rand() 1 0 9,800
rand() 2 1 11,000
rand() 3 1 12,000
rand() 4 0 11,500
Each time I press F9, the Account value changes because the win/loss is generated randomly. Assuming, I press F9 100 times, how do I create a scatter plot chart with a best line fit for all the account values. I know how to create the scatter plot but how do I save all the values everytime I press F9.
I'm stuck at a point in a graph that I am creating. Attached is as far as I have gone and now i'm having a gap on how to take the 2006, 2007 which is already in graph and add in how these years compare to guidelines visually in the same graph?
for instance ratings 1-9 are grouped in guidelines 1-4, 5-7 etc. How do i add in the 3 guides against each point? I have thought about adding a secondary axis but not how best to demonstrate the range of 1-4 to appear behind or above those points?
I would like to create a chart in vba which contains 2 sets of data, both using the same x axis. The first must be a line graph, the second a staggered bar chart. This must be represented on one chart with data labels. Also, how do I change the colour of the plots?
View 5 Replies View RelatedI would like to use excel to plot a growth curve. I would like it to plot the points that correlate to my data without connecting them by a line. I would then like to give excel a formula and have it plot that line on the graph.
View 9 Replies View RelatedI am importing a text file and plotting some of its contents versus time. The file provides the end time and the step interval. I know that in Matlab you can define a set of values with the start, end, and interval, but I'm having a hard time figuring out how to do this with VBA. I have toyed with fill series, but no luck there.
Specifically, the file I'm reading in (a relay event file with voltages and currents) gives the maximum cycles as 15 and the samples per cycle as 16. Therefore, for each voltage or current sample, I need the time to show as 1/16, 2/16, 3/16, ..., all the way to 15 cycles. I have tried to manually do this and record the macro, but after I put in a few x/16s, when I try to extend the formulas down the rest of the cells, instead of continuing the trend (4/16, 5/16, 6/16, etc.), it repeats what I put in first.
$TC$2:$WX$3
is an indirect range that resides in cell B15. It is constantly changing and the expectation is that the X_Y plot would adjust accordingly. It represents the data range of the chart. The chart does not carry with it any title.
So how do I approach this without using vba? As always any input is highly valued.
I would like to generate a macro which can work on by importing an excel tabulated datas and plot it into several graphs in one click and added with a filter function would be best.
Here i link one of the sample of macro for this :
[URL]