I'm trying to loop through a worksheet where each row is an individual record. I need a macro to read the row and create a chart on a separate worksheet for that row, then move on until a chart has been created for each individual row. In English the problem is:
Read Row 1
Create chart based on row 1 data in new worksheet 1
Read Row 2
Create chart based on row 2 data in new worksheet 2
And so on
I am trying to write a simple macro to create a chart over the used range in a worksheet. The first part of the macro correctly selects the used range which in this case is A1 to F19 when I single step through the macro. A listing of the macro is shown below:
Code:
Sub AddChartObject()
'
Sheets("Sheet1").Activate
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
[Code]...
When I place the formula given in MyArea as an argument for the source data, I receive a syntax error, so obviously it is the wrong argument. Numerous attempts to correct it also failed. As a sanity check, I placed the used range in an argument for the source data and was able to create the expected chart. fix the syntax error in the macro
I have a spreadsheet created in Excel 2003 (which is what we use at work, unfortunately).
My employees periodically take a test to ensure they have certain items memorized (or are making progress to that end). The spreadsheet rows show all 46 of my employees, and their test scores. The columns are the dates that the tests are administered. I can create a line graph based on the chart data, and interpolate these data with no problems.
The problem is that there are 46 employees! 46 lines on the same graph make for a very cluttered, hard to understand visual. I want to simplify the view by "filtering out" some of the data.
I have an additional column in my spreadsheet for each employee's work area (Area 1, Area 2, etc), and another column with data based on first letter of last name (the values here could be "A-G", "H-M", "N-S" and "T-Z", for example). I figure i could filter my line graph based on these two columns. For example, somehow select just Area 1, and reduce the number of lines on the graph to 16. Or better yet, Choose "Area 2" AND "A-M" and end up with 7 employees (and therefore 7 lines on the graph).
Here's what i have tried:
1) Select the work area column, and use the Filter, which created a drop-down list at the column heading. When i use this drop-down list, i can easily filter the data in the worksheet by Work Area, but this is not reflected in the line graph, which still shows all 46 lines. The problem was that i forgot that i had set the Calculation Options to "Manual". Setting this to "Automatic" (or leaving it on Manual and pressing F9) solved the problem, as the chart now updates when i use the filters. Calculation options are under the "Formula" tab in 2007, or in Tools -> Options -> [either calculation or formula, i forget what it's called] in 2003.
2) Create several separate line graphs in several separate sheets. I wouldn't want to assign someone else the task of maintaining a spreadsheet of such inefficient design.
Trying to create an excel chart to create totals based upon different keys. I
need to be able to calculate how many customers there are by Manager and then
By Rep. Then to figure out how many were New, Current, Total # of RSVP and
attended for that Rep. Below is how I have started but I am having some
problems getting certain parts. I know when I get one the rest will fall into
place. I can calculate how many total customers by manager and by rep just by
doing a Countif command but how do I determine the # of New, Current etc. Is
there a If Than command? Managers Totals are simply his reps totals.
Example..
A B C D E
F G
1 Manager Rep Customer New Biz Current # RSVP # Actual Attend
Need totals to look something like this....
A B C D E
F G
1 # of Cust # New # Current #RSVP #
Actual Attend
2 Manager
3 Rep 1
4 Rep 2
I need to reference the projected and actual expenses from the total on worksheet 'expenses' So i did so, however, if I change the drop down on the expenses worksheet to only display housing data, then the projected and actual expenses on my budget worksheet changes as well to the new data portrayed on the expenses worksheet.
I need to reference the cell, without it changing when I change the category display, but I need the cell to change accordingly if I enter new data in the overall tablet on the expenses worksheet.
Or do I need to create a seperate worksheet that has the data in and reference my cells on my budget worksheet to that new worksheet?
The new worksheet is created to the left of the existing source worksheet.
View 2 Replies View RelatedI am trying to create a pivot chart that show the average response times in hour but for some reason my charts looks not right. The axis show a max of 1 but the graph itself showed us up to 17. I think easier to explain if I attached the worksheet.
View 2 Replies View RelatedI've used trend lines to find the mean and average but for some reason I have not been able to set an upper and lower limit. without introducing a new column.
View 6 Replies View RelatedI have two items: Written Premium and Earned Premium. Each of these items has a forecast and actual number for two months. How can I create a line chart (with dots) that will show both of these items. I've attached a spreadsheet.
View 1 Replies View Relatedhow do you create a bar chart with values and %? Spreadsheet attached.
View 3 Replies View Related
Originally Posted by Question
Create a well labelled pie chart on a separate worksheet to show the profit made by each of the Liverpool departments to the overall profit for 2006. On the labels show the percentage contributed by each department.
I want to create a pie chart in Excel 2007. The data is not next to each other in the columns. How do I create a chart so that it includes the legends as the various departments and the data shown as the figures given under 2006?
Can you create a flow chart in excel? If yes, how?
View 9 Replies View RelatedI have a table of data which moves up and down my report depending on user input changes to the source data.
I have written some VBA code to generate a chart based on this table of data. I have managed to create a basic chart from this table. However I need to change the series (on the chart) from rows to columns so that it is displayed correctly. For this I need to have the cell references within the code belonging to the actual chart.
If I was writing the code for the chart with an absolute reference I would write it as:
ActiveChart.SetSourceData Source:= Sheets("Group").Range("B50:F53"), PlotBy:=xlColumns
This obviously works fine, however when a user makes a change to the source data the table is now out of sync with the chart references.
I am trying to write it as:
ActiveChart.SetSourceData Source:=Sheets("Group").Range(ActiveCell.Offset(-1, -1), ActiveCell.Offset(2, 3)), PlotBy:=xlColumns
Where am I going wrong?
My full code is as follows:
Private Sub CreateRegionChart()
Worksheets("group").ChartObjects.Item(2).Delete
Range(ActiveCell.Offset(-1, -1), ActiveCell.Offset(2, 3)).Select
Charts.Add
ActiveChart.ChartType = xlColumnClustered
'ActiveChart.SetSourceData Source:=Sheets("Group").Range(ActiveCell.Offset(-1, -1), ActiveCell.Offset(2, 3)), PlotBy _
:=xlColumns
ActiveChart.Location Where:=xlLocationAsObject, Name:="Group"
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "Title"
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Label"
End With
Is it possible to create Cascade Chart without the Excel add-in?
View 5 Replies View RelatedHow can I create a box chart showing graphically a median, 1st and 3rd quartile and a minimum and a maximum?
View 5 Replies View RelatedI would like to re-create the attached chart (.jpg file) but have tried for the past 30 or so minutes with no luck.
I know how to arrange my source data. I just do not know how to combine the stacked columns with a line graph.
I'm making a risk chart which i want to select data automaticly.
It currently is possible to select a characteristic. After selecting the characteristic i want the chart to update, having only the risks with that characteristic in it. But it also has to select on impact level and chance%.
Is there any way to let Excel auto select the Risk discription and copy it into the chart?
below are 2 pictures, 1 an example database of risks and an example of how the chart should, more or less, look like when i select the financial characteristic.
I am trying to create a horizontal bar chart with a product code data set. The number of codes will increase over time. For each product code there may it may not be a sales value and that sales value will increase over time. I am trying to plot the product codes on the y axis and sales value in the x axis.
View 3 Replies View Relatedis it possible to create a pie chart with the colours that are in the cells (fill colour) which contains the data.
View 1 Replies View Relatedhow do i make a bar chart on Excel! 2010
Basically i have these figures
Male : 21
Female : 18
I want to make a bar chart, When i use Excel and try to make it - i get a chart which shows the right column height but the Male and Female bars are BOTH IN 1 Colour. How do i make it so that male bar is blue and female is pink.
combobox1 = dog, texbox1 = 1500
combobox2 = cat, textbox2 = 1000
combobox3 = duck, textbox3 = 750
Is it possible to type in VBA coding to create a pie chart in excel with comboboxes and textboxes value?
I currently need to create around 1200 chart images using excel for a report series I am performing for a client. I have been trying all kinds of different things, all failures, to automate this process. My current method is to filter a pivot table on the building I am analyzing, copying the chart, pasting it as a picture in Ms Word, then saving that image as a Picture. Obviously, this process is quite lengthy, especially if I multiply that over the course of all 1200 images.
I am looking for a solution using a macro, vba, or a combination of things to automate this process and maybe even create the jpgs automatically?
Trying to create a chart from a table of data, however my column of data has zeros throughout. How do I insert a chart with just the data that are not zeros?
View 1 Replies View RelatedI am trying to have a list box that when clicked will change the chart data to whatever is selected. There are 2 options you can choose from. Order Cost (Net) and Order Total (Gross) The problem I'm running into is that the data is in 2 different rows. How can I create the drop down box to display the one that is selected? ...
View 9 Replies View RelatedI'm trying to create a very simple map.
I've got three columns.
Member, X, Y
Naturally, the first column contains someone's name.
The other columns contain XY coordinates.
These coordinates start at 375 and end at 499 on both axes.
I'm needing the points to show the member name and xy coordinates in the popup when hovering over the point.
How do I accomplish this?
Here's some sample data.
MEMBER X Y
JOE 397 397
JIM 421 384
JANE 467 406
JEFF 389 395
to write a code that would create a chart automatically in another worksheet when a button is clicked.
I have attached the sample data that I am working on.
Each row in the sheet represent 3 coordinates, which are:
coordinate # 1 = start, 0
coordinate # 2 = centre, level
coordinate # 3 = end, 0
I need to plot a stacked chart. I have attached a sample of it. I need to plot, category As X and subcategory and and its percentage as Y (stacked chart). In the attached sample I plotted a chart. The problem is, the series name showing is not correct. It takes the series name from the top row.
View 5 Replies View RelatedI have downloaded a file called "scroller.xls" under the section "Excel charts". The file was made by Andy Pope and shows how to make a graph dynamic by combining Named Ranges and a scroll bar.
My chart is actually XY scatter chart with data points connected with smooth lines. I followed but when I start scrolling, the data points (smooth lines) got "eaten up" as I move.
I tried line chart and it works perfectly.
Does scrollbar work for XY scatter chart? Is there a different formula for XY scatter chart?
And I want the chart to be in new sheet, but I couldn't put the scrollbar in new sheet. I would like to know if it is possible when the chart is located in new sheet because my chart is quite large.
I tried so long I finally gave up and drew this by hand in MS Word:
But I wonder if you guys could help me chart this automatical in Excel.
I want to chart the time period a ship (Vela, Serpentine, Rainbow etc) are contracted. I want a specific color for the firm contract, and another for the remaining optional contract. If a ship is under construction I also want a bar showing when it's done.
Each ship has a rate. I want this written on the bar. In "Vela's" case there are to rates for the same contract: The first 740 days the rate is 24,5 the rest of the period it is 29. I also would like to be able plot an additional contract for the same ship for example after "Syrena" is done in yr 2009.
I have code in a worksheet that creates a new worksheet when clicking a button:
View 3 Replies View Related