Vba To Switch Columns To Rows In A Line Chart
Nov 5, 2009vba to switch columns to rows in a line chart
I have the following
ADVERTISEMENT
Transpose (switch) Rows Into Rows And Columns Into Columns?
Jul 28, 2013i need to mark some row (which has some content written in), mark other row(with data too) and switch/transpose them mutual. when i was trying transpose method, which is using for switching rowns and columns, it wrote me error, that data are overlapping. it means it cant work on same things (rows > rows, columns > columns).
View 14 Replies View RelatedA Chart Will Columns And A Line Chart Below??
Dec 15, 2007I can create a column chart in excel comparing sales in 06 v's 07 for each month in 07, what I'm aiming to show on the chart is how sales have grown or not over a comparative period. A simple enough graph, I end up with about 24 columns (2 for each month and then a gap between each month).
I now want a line chart to show the performance of an index over the same time period, lets say the FTSE100.
I don't know how to get the line chart under the columns on the same graph, using the same x-axis with a small y-axis to the left. I could propably figure out the y-axis bit if I could only get the line chart below the columns.
Excel Command Line Switch For (Read Only) Shortcut Not Working
Jul 31, 2014I've recently created a macro which takes a .csv file and scrubs the data and dresses it up for a report. I've finally got it running without any problems and have added it individually to 5 different user accounts on my network as an add-in, but need a way to share it across a computer network without allowing others to edit the file.
The report is generated multiple times a day by the different users, none of whom are very computer literate (not that I am much better, myself), and the macro over-writes the old file each time. I've read that it's possible to simply create a shortcut to the file that automatically opens the spreadsheet in read-only format, which would be perfect for what I'm trying to do, but I haven't been able to get it to work so far.
My current shortcut pathway is similar to this:
"C:Program FilesMicrosoft OfficeOffice15EXCEL.EXE" /R "C:UsersBenDocumentsOT Master.xlsx"
On my computer at work (Windows 7) the shortcut simply opens the spreadsheet so that anyone can edit it, instead of as a read-only file. On my computer at home (I'm trying to experiment) (windows 8.1) it won't even let me save the shortcut, saying I need to provide administrator permission & then cutting to a window that says "access denied".
I won't have the pathway for the actual file I'm trying to create a shortcut for until tomorrow when I get back to work, but I've formatted it essentially the same, directing to the excel.exe file, running the switch "/R", and then directing it to the actual file location.
The ultimate goal is to have multiple people be able to view the file without locking out those who need to update it.
Color Column Chart Columns Based On Thresh-hold Line
Nov 21, 2007I want to show 8 members of staff's names, with their sales closing percentages. I want then to produce a chart showing their percentages as a column with a line showing 16% going across the chart showing who is above and who is below the target.
Ideally i would also like to change the colour of the columns or background of those below the line to show who is under target.
Chart - Allows To Switch Data Range
Mar 16, 2014I have data in columns A to Z. Column A has the name of Bonds and columns B to Z have different returns for those funds. I would like to create a scatter plot chart that allows me to switch which column to pull the data from in addition to column A which will always have the name of the Bonds.
For example in addition to the name in column A I would like the chart to plot data from Columns C and F on the x and y axis respectively.
I'm thinking of copying column A to a new tab and then having a drop down box in columns B and C to copy over values from the 2 columns I select. How can I get a drop-down box to copy over values from another column?
Multiple Lines To One Line (Rows To Columns)
Aug 12, 2014I have is a list of the over 500 people with one line per college degree. Some have up to 4 or 5 degrees. Each have SSN as unique identifier.
I need to consolidate into one like per person with multiple columns one for each degree.
See attached : Test Degrees.xlsx
Split Line Break Multiple Columns Into New Rows?
Sep 17, 2013I'm having troubles with a spreadsheet and unfortunately don't know enough VBA to fix it. I have two columns, each with data like so (standard text) separated by a line break:
Object1
Object2
Object3
value1
value2
value3
And I need them separated like so:
Object1
Value1
Object2
Value2
Object3
Value3
with other items in the row from other columns applied to the new rows accordingly.
Any script/macro/tool (even non-Excel) to do this effectively (over 800 rows)?
Cannot Just Switch The Columns Around
Mar 17, 2006I have created a database of names & addresses from a software program called "CLIP" into excel, which in turn will become a label mail merge in MS word consisting of 900-1000 customers (for a mass mailing).
The problem is, the names were created last, first and I would like to change them to first last. Is there a way to do that without manually typing them all in again?
The names are in one column, so I cannot just switch the columns around.
Excel 2010 :: Add Pie Chart Into Data Point Marker On Line Chart
Nov 27, 2011I am looking for a creative way to display a pie chart within a data point marker of a line chart.
My database has 3 value columns, Type1, Type2 and the Total (Type1 + Type2)
these are recorded per day (Date, in Column A)
I have a line chart that displays the total by date, but I want to find a way to display the percentage split of a particular day by type.
I was thinking to load the chart image into the Data point marker, but i don't think that is the best way as the data is updated daily and I would have to do it each day for a few line charts.
The other way I was thinking about was to have a generic Pie chat in the Line chart (Maybe in a corner) and the pie would update depending on way date series was selected or Mouseover'd)
the way that I am approaching it at the movement (Not the best way and by far not the coolest way. Is to have a list of all the dates in a column next to the Line chart and using some VBA, what ever date is selected in the column the pie chart displays the corresponding data. But eh challenge is that when there is alot of dates, I am going to be scrolling up and down.
I am using Excel 2010, but I cant not use the slicer's as the other users do not have 2010, they have 2007.
Adding Comparison Line Chart To And Existing Population Pyramid Chart
Jul 14, 2012I have created a population pyramid and want to add another chart on the secondary axis which I can do. The part which I seem not to be able to complete is getting the line chart secondary axis to read from the primary y axis. It seems to add a new axis, even when I delete this the line chart does not read correctly.
View 1 Replies View RelatedShow Missing Values In Pivot Chart (line Chart) Axis?
Apr 18, 2013How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.
View 1 Replies View RelatedOverlay Line Chart On Top Of Stacked Column Chart?
Feb 15, 2012I am trying to overlay a line chart on top of a stacked column chart. The stacked column chart is a chart where the x axis is dates and the y axis is amount. The line chart is a projected amount that I will reach in few years; the x axis is the date while the y axis is an amount. I can get a chart that has a line and stacked columns, but ever time, the dates get messed up. The line has an extremely wide date range while the columns only have about a month of data.
View 9 Replies View RelatedLine Chart - 12 Month Chart Moving With Dates
Jan 22, 2008Is there a way to display only the current month and the past 11 months in a Line Chart in Excel? So if I was to print Jan 2008 Excel graph, it would only display Feb 2007 - Jan 2008 data charting.
The spreadsheet of the data contains data for Jan 2005 - Jan 2008 so far, but only the current month with the past 11 months should display in the line chart depending on what is the current month.
Chart Not Plotting Hidden Rows/Columns
Sep 14, 2006I have mapped data from Sheet1 to Sheet2 and created graphs in Sheet2 using the data. but when I hide the rows in Sheet2 the Graph is being cleared off. Need a solution so as to display the Graph in Sheet2 while hiding the rows in the same sheet.
View 2 Replies View RelatedColumn Chart With Line Chart And Percentage?
Sep 15, 2014In the attached file I have the data which shows me the market size in value, my market share in value & I did a calculation to get the percentage. What I need is a chart that shows me the market size in column graph, my market share in line graph and I want the percentages to be showing also.
View 3 Replies View RelatedPareto Chart, Set Line Chart Origin At Zero
Nov 28, 2008I have a pareto chart(Bar & Cumulative Line Chart) that I would like to have the line orginate at x = 0 & y = 0 without changing the position of the other points on the line chart.
Basically this is for better visual appearance. When I add a 0 to the table, it skews the alignment of the line chart with the corresponding bar chart.
Line Chart To XY Chart And Vice-Versa
Feb 5, 2010Attached is the sample data worksheet. Chart 1 is XY type chart using Seconds (2nd column of sample sheet as x-axis from 42510 to 42530). How do I change it to Line chart using Time (1st column of sample sheet as the X-axis) retaining same data from 42510 to 42530 on both primary and secondary axis?. And how do I again change it back to XY chart?
View 3 Replies View RelatedSUMIFS From A Chart With Duplicate Values In Rows And Columns
Jul 28, 2014I am trying to do a SUMIFS from a chart with duplicate values in rows and columns.
Data looks like this:
So this is basically sales of different products (columns) on different routes (Rows).
I want to add up a total for all the same kind of products eg. Magnum for each route eg. Local Top End.
Read Pdf Or Doc File Line By Line And Then Parse Data Into Proper Cells And Rows?
Feb 23, 2013I have the data to import / read in a pdf, in a doc, or in an Excel worksheet whichever is easier to use. I need to import the data, parse it into the correct cells for that row and then repeat the import until the end of the file. Not all the cells are in each group of data to import, so those cells will be null for that row. Some of the data for one cell may be in up to 14 lines in the data file. I have be concatenating these data rows into one cell. There are 48,000 lines in the file to import or I would do this manually. I am assuming that doing this in VBA would be the most efficient method.
View 11 Replies View RelatedSwitch Statement Is Too Long For VBA. To Make The Switch Statement Work Over Two Lines
Jan 6, 2009I have created a very long switch statement, which is too long to be placed in one row in VBA. I have attempted to put a space and underscore at the end of one line and continue the statement on the row below by placing a comma at the start of the second line. VBA will accept my efforts, but when I run the statement in the immediate window, the following error appears.
"Invalid procedure call or argument"
I understand that there are certain rules where I can split a switch statement onto two lines, yet I do not know what they may be.
Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart
Nov 1, 2006I am trying to graph the following data in an area chart with line charts superimposed on the area chart. I have a lot of data (and a lot going on) so I'm trying to figure out the best way to show this in excel from a functional standpoing (i can't get this to work in excel!!) to also an asthetic standpoint (dont want it to look terrible or illegible). This is what I'm trying to chart:
1) Weather data (temperature) by region:
So one region, would be: Northwest
I would like the "area" (so a shaded region) to be the min/max of the temperature data for each month.
2) I would like to show the temperature for each year as a line graph on the chart - so you can see if a year falls in or out of the shaded region.
3) I would like to show a company's sales increases across the same months per year as separate line charts. I may choose to just show the biggest outlier year in the end... or to show 2006 (the latest data).
What I am trying to convery with the chart is that the company's sales is or is not tied to weather deviations. I have attached an excel file with the data. I haven't been able to use the area chart or get a two axis chart to work or get it to look even remotely professional.
New Line With VBA On Rows And Merging New Line
Mar 14, 2013The following code adds a new row at a given point (Based on a fomula in a column returning "1")
The code works well BUT I want to merge this new row from column A to coulmn M
Im not sure how to do this, (I dont want to merge the entire row)
Example Code:
Sub ExtLne()
Dim Lastrow As Long
Dim I As Long
Lastrow = Range("A" & Rows.Count).End(xlUp).Row
I = 1
While I
Line Chart To Zero (VLookup)
Apr 7, 2014I have a couple of charts getting their data from a vlookup formula, example,
=VLOOKUP($A$8,CPPDATA!$A$4:$O$27,5,FALSE).
I really need to prevent this from happening. I'm sure there is a way.
see image
[URL]
0 Value On Both X And Y Axis In Line Chart How
Jan 4, 2008i want 0 values to start at x and y axis.
basically i want time in secs on x axis starting a 0 upto 4.4 secs
How Do I Not Graph A 0 Value On A Line Chart
Oct 26, 2009I have created some charts for my work and one of them is a line chart that spreads across one year with values for each month. Well they want the graph to always show one month ahead of where we are out. So there is actuals in for Sep. but then the line graph drops all the way to 0 for Oct. I don't want to have the graph bottom out when there is a zero. Does anyone know how to fix this?
View 9 Replies View RelatedLine/candlestick Chart
Apr 28, 2007I am trying to graph a candle stick chart but also have a series which is a line in the graph. I have attached the file. I am trying to figure out how to get get column E as a line in this graph.
View 4 Replies View RelatedR Squared In Line Chart
Jul 27, 2007Hi, as you can see in this chart I am plotting TOTAL company sales against its three merchandise components - men's, women's, and accessories. My issue is that when I had two rows to just show company sales against one of the merchandise categories -- and I Go TO TRENDLINE and show the R-Squared, it is ALWAYS THE SAME= 20%. CLEARLY, something is wrong beacuse (a) its different numbers for each of the three merchandise categories and (b) these three categories make up the total comp so CLEARLY it should be a higher R-squared than 20%. How Can I get it to properly read the R-Square.
View 9 Replies View RelatedBar-line Combination Chart
Sep 28, 2007I have a table with 7 rows and 7 columns:
First 6 rows - months i.e. Mar to Aug
7th row - Average no. of Breakdowns
Colums - Mon to Sun
I am trying to create a bar-line chart with the 'Average No. of Breakdowns' to be on the 2nd Y-axis and displayed as a line.
The rest of the data would be on the primary Y-axis and displayed as bars,
But I am unable to get what I want. Instead, the data on the 5th and 6th row is displayed as lines. I even tried formatting these 2 rows to the primary Y-axis but they are still displayed as lines.
Add Line To Chart To See Trend
Dec 5, 2007On top of these graphs, i draw a line (insert a line shape) corresponding to a certain gradient in the data presented. I do not want this line to be exact (i.e. not point to point) as it is best to be drawn by eye so that the general 'gist' of the data can be found. What i would like, using any method available, is to be able to find the gradient of this line i have just drawn which obviosuly must be done taking into account the scale of the graph. The scales of the graph will not be consistent across all applications.
View 4 Replies View Related