axis

On a spreadsheet I have there are a number of bar charts that are linked to a drop down box to select the criteria which feeds it from my data source. All this is working fine, but the issue I have is that the different selections have a wide range of scores so if I just have 1 axis either some...

So I have the following code....I am fairly novice so I am not sure this is even the most effective way to do this Sub BuildTable() Application.ScreenUpdating = False Dim copySheet AsWorksheet Dim pasteSheet AsWorksheet Dim LastRow As Long Set copySheet =Worksheets("Combined...

So, I have this table where each row has data about a supplier's deliver, with a final "rating" for that delivery. A supplier may have multiple deliveries in a month, or none, of course. The Pivot Table has the Y axis showing the suppliers names, the X axis shows months, which aggregate all the...

Hi, Totally new to making graphs in excel - wondering if anyone can help. I want to make a line chart with multiple lines and with date value on the X axis. So I have sheet1 - range z2:z5001 as dates. (this is a list of dates that is dynamically added to - what I want to use is any dates on...

Hello, Does anyone know the formulas excel uses to develop and show an axis range, major grid lines, minor grid lines, and increments when graphing charts? Not sure if it matters, but I'm specifically trying to figure this our for a scatter chart type. Thanks in advance!

Hi, I have a large dataset. I need to use the sumproduct function to retrieve data from the dataset - namely if certain criteria are met on several columns on the x axis, and several criteria are met on the Y axis it will retrieve that value: =SUMPRODUCT(('Daily Source'!$C$3:$ZZ$3='Daily...

I'm trying to follow this tutorial https://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html and am running into some chart creation problems. I've recreated the tutorial up to this point: But my use case needs a full days worth of data at one-minute intervals so I 1) moved the...

In a 2010 Excel chart, can I have different Y-axis scales (a primary and secondary axis) for a line chart? I see how to make a secondary Y-axis for bar charts, but can't figure out how to apply this to a line chart.

Hello all, Have a table which looks like this: in A1 is a value of 3000 in A2 is a value of 100 <colgroup><col><col span="2"></colgroup><tbody> X Y Side 25 55 Z 25 55 Y 115 55 Z 115 55 Y 205 55 Z 205 55 Y 2233 75 Z 2233 75 Y 2302 45 Z 2302 45 Y 2950 50 Z 2950 50 Y...

I have a sheet of data. There are 24 columns of information, and 1051 rows. It is simply a flat file of failure records. Column A is a date column. There is a date for every failure. Sometimes there are several on the same day. So I want to line graph failures per month so in May there were 7...

I'm not sure if this is possible, but figured I'd be the (possible) hero in my department and ask. The desired result is below. We're trying to compare CLIENT 1 to PEER GROUP. As you can see, it's plotting two different sets of data...but not really. I had to manually color the "peer group"...

Hello everyone! I've recently got a task to do in excel: "There are points A(-1,0) and B(3,0). Find point C, for which the ACB angle is a right angle." There was also something mentioned about the method of searching an axis??? I understand this and I know how do do it on paper but have...

Hello, I have simple data that I wish to chart in Excel. The format is as follows: 2018.08.06 18:00 7441 7442.5 7439.8 7440.2 2018.08.06 18:30 7440.5 7442.4 7439.8 7441.8 2018.08.06 19:00 7441.9 7443.7 7440 7442.2 The first chart I posted showed the time as well as the...

Hello all, I have a chart in Excel that changes as the selected source data changes (this is done with some simple VBA). The problem is that the source data could be number/currency/percentage dependant on what is selected. Is there any VBA available to auto update the number format on the...

I am working on constructing charts with VBA within a For loop. There are two main problems I am facing. The first iteration generates a chart with five data series despite my intention of including only two. One is a multiple range source, and the other two are 1 values. On the second...

Hi everyone, I have made a stacked area graph which looks lovely but my x axis values don't start at zero aren't aligned with the axis ticks :( Does anyone know how to align? https://ibb.co/ceN1Nq Thanks:)

In spite of my having selected the dates i want to appear in the x axis my chart continues to return automatic dates (01 jan 00...) I have tried every variant of axis formatting. I have made sure that the column in question is formatted correctly, i have selected and deselected the range.. I am...

I have the following code building charts, but am stumped as to how to successfully include a secondary y axis. the hasaxis properties don't seem to be including a secondary axis With ch .HasTitle = True .ChartTitle.Text = aa & StartDate & " to " & EndDate...

I am working on putting together some charts in VBA and could use some assistance with defining properties in the chart. With ch .HasTitle = True .ChartTitle.Text = aa & StartDate & " to " & EndDate .ChartType = xlLine .SetSourceData Source:=Range(RngStart & ":" &...

I am using excel 2016 for mac, and am trying to use the "horizontal (category) axis labels. in charts" But I can't seem to enter any thing into the box for this. Ultimately I want to be able to put data labels that are not the numeric x and y axis values, but cannot find a way to do that...