I noticed that if I have data that trends downward a straight line trendline will suddenly create a negative vertical axis. But if my data is only positive, how would I prevent that negative vertical axis from appearing?
yer.xlsx
I am using the following format code for the y axis of a line chart. I am shortening the axis to show 3M or 500K instead of $3,000,000 or $500,000. I can't get it to work with negative numbers, I get the full $3,000,000. Somewhere I read you can only do 3 formats in a formula. Is there a way to include negative numbers using this formatting?
[>999999]$#,,”M”;[>999]$#,”K”;$#
i have this data.
WeekFRM CURRCY Account val val2 val3 val4
42100BBHBANK403522
43100BK200 001310
44100ABBHBANK3013
45100ABK200 9043
46100CBBHBANK10106
47100EBBHBANK903420
48100EBK200 503527
How do i get this into a chart, with week along the bottom, Amount on the left. This is starting to be a pain now as i need to seperate by currency, but a pivot chart looks really realy messy with all the drop down boxes and stuff. I dont mind using drop don boxes, in fact, its going to be essential. but the pivot one look horrible.
Two questions:
1) How do make values on x-axis as words? E.g. apples, oranges, etc.
2) Is it possible to have the numbers on x-axis in descending order? If I can figure out 1), I can do this as well, but it would be nice to know if it is possible to have the numbers on x-axis in descending order.
Excel Chart can fit various trendlines in a given set of data. For example we can get linear, as well as exponential trend line for same data set.
How do I decide which trendline best represents the trend in data? Shoud R Sq be used as parameter to see the best fit?
I am doing financial ratio analysis of a company for five years and I need to show the ratios in a trendline. I have generated seperate line charts for each ratio, but I want to combine the charts and have multiple trendlines for multiple data series in a chart.
View 3 Replies View RelatedI need to add small trendlines next to some data in a score card and also working out the calculating Compounded Annual Growth Rate.
1) how do i just extract the treadline, i have created the graph but don't know how to just extract the trendline
2) is there a simple calculation on excel to work out the CAGR?
I have a spreadsheet with golfers handicaps, golfers names down the left in column A in rows 3-35. Row 2 has the event numbers titles 1 to 18 (18 events in a year). i need a graph that has the person as the vert axis and the horizontal axis needs to be the event numbers, so i can read down for the person and across to see how there handicaps change from each different event. i have attached the data below.
View 1 Replies View RelatedI've put together code to construct a chart
It all works fine but I've noticed an odd quirk which I can't explain nor can I seem to fix. Here's the (reduced) code :
Code:
Dim appExcel As Object ' Excel Application
Dim chtPareto As Object ' Chart
Set appExcel = CreateObject("Excel.Application")
Set chtPareto = appExcel.Charts.Add
With chtPareto
' Primary category axis
[code]....
The category (x) axis title should be horizontal, whereas the value (y) axis title should be rotated. Stepping through the code, when I .SetElement for the category axis title, it appears horizontal as planned. However, as soon as I .SetElement for the rotated value axis title, the category axis title also rotates.
I have some numeric data that has to be put on a log chart. but there is no option for log charts. so i converted my data to log and then drew a chart but i am unable to edit the axis intervals and starting axis value. whenever i change the value it gets back to its default value,ie 1. can anyone tell me how to draw log chart or how to edit axis intervals and starting axis value?
View 6 Replies View RelatedI need to create a graph with a 2 x axis and a single y axis. For example:
Pressure ( PSIA) Solubility (mol %) Velocity (m/s)
200 0.024 1
300 0.036 1.2
400 0.041 1.8
I need the two x axis to be pressure and solubility and the y axis to be velocity, with the data being demonstrated by a single plot (I have only managed it with two plots which does not demonstrate solubility's relationship to pressure ).
For example at a pressure of 200 PSIA (lower x-axis) and solubility of 0.024 mol % (upper x-axis) velocity was found to be 1 m/s.
I am trying to reproduce a graph similar to this: [URL] ....
How to get the Y axis in the center and two distinct bar charts on either side.
Sample data can be found here: [URL] ....
how to incorporate another category and value axis to my existing chart.
1. I need to add a rank axis derived from my data column (C6-C15). This column should rank from highest to lowest and create a tie if any number is repeated. I have arranged the rank column in cells B38:L38 as they would appear. I would like this to appear on the top or bottom of the bar graphs.
2. Second I need to add the frequency of hits which = 3 derived from cell J1 This should appear on the chart were it is currently titled. This should create another bar graph colored green and labeled 3.
3. Lastly the numbers axis can remain the same as it appears on the chart or if it would be better to align as shown in cells B43:L43.
What is the best way to have both horizontal and vertical axis as value axis?
View 2 Replies View RelatedI have a large dataset (24000 rows) that requires me to multiply two different columns of integers. In some cases, the two integers are both negative and multiplying them results in a product that is positive. I actually need that product to be negative rather than positive. I can't quite seem to figure out the best way to accomplish this.
View 5 Replies View RelatedI have data that comes from a subsytem that places the negative sign at the right of the number, so it is recognized as text. I can get around this using find and replace and then a second step to multiply that by -1, but is there a formula that can do this for me?
I was trying if(right(A1,1)="-",TBD,A1)
I have data starting in E7. I want it to go down the column and find the negative numbers. If it finds one then I want it to change the number in the row to the left of it to a negative. So if E67 is a negative number, make D67 a negative and so forth down the line Sounds "simple" but how do I do it?
View 7 Replies View RelatedI have a data set that is a spectrum of (y)intensity vs (x)energy I was wanting to add an additional X axis at the top of the graph showing the wavelength conversion for the energy value, is that possible in excel? and if so how?
View 1 Replies View RelatedI have data in range J2:J365 , H368:H401 & J403:J827. i want to check wether this range have negative values or not if yes load all negative values in the listbox1 by clicking checkbox.
View 3 Replies View Relatedhow do you create a graph with a field such as vendors on the X-axis, but with dollar values spent on the left side of the y-axis and percentage of total dollars spent on the right side vertical axis?
View 3 Replies View RelatedI would like to add a vertical axis to the right of my plot that looks exactly the same as the left axis. The only way I found to do this is to add a secondary axis. However this axis is based on a data series and it does not match the left axis.
How can I make the left and right vertical axis look the same.
Any way to get the values in a chart/graph by putting an specific X axis value.
E.g. There is relation between Gauge height and Flow
GaugeFlow
0.30500.320.100220.3413880.275390.3813470.855280.4017081.322240.4137521.692480.4333542
.468280.4529963.431060.4823795.30220.5115577.774290.5229628.94510.56120913.535920.58917.68
If I draw the curve with Flow on X-axis and Gage on Y-axis and then want to know the flow at Gage 0.53m.
OR
By putting flow value to know Gage height.
I'm working on a employee evaluation form. I'm using a Pass/Fail system.
I have a cell designated for PASS & one for FAIL. In these cells, I would put
"YES" if they passed, "YES" if they failed that section.
How can I prevent someone from mistakingly entering Yes in both cells?
I've generated a sheet where, based on the total run hours of a generator set using a given fuel type, we can determine which engine to run on what fuel when. The problem I've run into is that if more than one engine has the same runtime, the chart returns just the lowest numbered engine and eliminates the remaining engine(s). What I'm trying to do is make it so that when this occurs, the suggested engines show up in numerical order. For example instead of 1, 1, and 1 showing up on the chart, something like 1, 2, and 5 will show when they all have 0 run hours. I've attached my chart below with some engines having the same runtimes. RunOrder.xlsx
View 5 Replies View RelatedIs it possible to prevent the VBA window from popping up if an error occurs when running a macro and the user then selects debug? I've locked the code for reading but I was still able to change the code and save it!
Basically, I want the code to be unchangeable unless done through a known password. What I don't want is some user who may accidently stumble upon the code and change it unwittingly (or voluntary).
Is it possible to prevent a user from being able to move a userform around the screen area (clicking and holding caption bar)? I am captureing a image and using Pixels coordinates on the capture and need the userform to stay in the center of the screen or the image will not be catptured. The StartupPosition is center of screen, tried
View 2 Replies View RelatedI am using the following COUNTIF formula which I am sure is supposed to prevent '#N/A' from appearing (According to [url]
View 12 Replies View RelatedI have made an integrated timesheet for everyone at work. Problem is, people will be funny-beggers, and want to password protect their workbooks.
I want to be able to prevent EVERYONE from creating passwords to protect their workbook.
I would like to prevent the user from inserting rows. I know that ater versions of Excel have built in "Protection" features which would easily accomplish this. Unfortunately, our company uses Excel 2000.
I have keyed in a constant value in cell B100 ("bottom" of the practical range). I have tried ...
Private Sub Worksheet _Change (ByVal Target As Excel.Range)
MsgBox "Range" & Target.Address & "Was Changed."
If Range ("B100").Value = "" Then
Application.Undo
MsgBox ("Do Not Insert or Delete Rows")
EndIf
End Sub.
The problem with the above is: The "Change" macro does not seem to detect the insertion of rows. It does, however, detect the deletion of rows.
I have an Excel 2007 file that is a work of art. Users manually copy several rows and columns from a table on a web page and paste it into my Excel file. This turns my beautiful Rembrandt into a Jackson Pollack mess. The formating of my cells is replaced with the formating from the web page. Is it possible to make the Excel file ignore the formatting of the data being copied? As a default?
View 9 Replies View Related
