secondary

Good day, I have two sets of data, one plotted on the primary vertical axis and the second plotted on the secondary vertical axis. The first data set is fixed, the second data set (on the secondary axis) is selected from a combobox list (13 possible choices). I'm looking to change the color...

Hi, I have a column chart with both negative and positive values. In the same chart I have a secondary axis which only contains positive numbers. What I want is for the starting point of the secondary axis to be the zero point on the primary axis. Currently the zero point on the secondary...

Hi, I have a code that opens a workbook, dumps some data into it from primary workbook and runs a code in the secondary workbook. The secondary code has a msgbox in it that needs to be there for different uses. How can I change the msgbox code to something like: If workbook is open that...

Hi, How can I create a space between the two bars in the pivot table? I am using a secondary axis for the Percent column. Cheers, Tamir

Hello all, I am in need of looping the macro code below Sub Test() If Range("D2") = "Secondary" Then Range("J2,I2,R2,S2,T2").ClearContents End Sub The code above works great for the one line it is clearing but.. I need it to test conditions from 2 to 6000 on each column If Range("D2") =...

[/IMG] Hi, I need to create a combo clustered chart for the above but I'm having trouble getting it to display correctly. Primary axis - cull values -24 & -30 side by side - death values -23 & -25 side by side Secondary axis - cull values -4.1% & -8.0% side by side - death values -3.9% &...

Hi all, Using Excel 2016. I have 2 series Clusters Columns I added an XY Scatter with Lines on Combo Chart on secondary Y and Secondary X Axis Not bad, but the vertical line is plotted over a column. Is there any way to get the vertical line to plot immediately to the right of of the column...

Hey How do i update a field but display values from another? I have a query based on two tables. it is used to display data in a listbox. there is a relationship between these two tables with Primary Key ID connected to secondary key ID in the other table. I want the user to be able to change...

Hi all ! I was trying to insert a secondary vertical axis in my graph but unfortunately I'm not able to proceed after step 3 for Excel. https://support.office.com/en-us/article/Add-a-secondary-axis-to-a-chart-025f91b8-d70a-4d4c-b645-1431ec1c8c97 Please tell me how to go about it. i cant see...

I'm trying to do a If formula for ARMY Promotions. <tbody> NAME RANK BASD TIS DOR TIG ZONE 7-Oct-17 FOX SPC 2-Feb-14 44 1-Jul-16 15 FALSE </tbody><colgroup><col span="3"><col><col span="2"><col><col></colgroup> This is what I'm starting with I need the zone Colum to give me Primary or...

In the main file I have employee ID and other fields in each respective column. In the secondary file, I have dates for courses taken that I wish to pull across using VLookup, but the multiple entries for the employee names are reflected in separate rows rather than columns. Example (In...

Hello everyone and thanks in advance, I can not create a slicer that filters not only by the main table, too by a secondary table that should be linked with the firts table with field key that is the reference. In other words, the main table is the one of students with a unique ID that is...

Hi everybody! I am trying to build a macro who read 5 columns (2 columns as x values and 3 columns as y values) of data and produce a chart with 3 curves. I would have a chart with a secondary x axis and only one y axis. There is anybody who can help me please? Thanks in advance Alberto

Hi, I am using Jon Peltier's code to refresh a dynamic chart range as follows: Sub UpdateChartSourceData() With ActiveSheet .ChartObjects(1).Chart.SetSourceData _ Source:=.Range("ChtSourceData"), _ PlotBy:=xlColumns End With End Sub The problem is that I have a...

Hello - I am attempting to add a series on the xlSecondary axis of a PivotChart of BarStacked type. Please note that the data for the other series is not contained within the underlying PivotTable/ PivotCache. However, I am having difficulty in getting it to work. Attached is the relevant...