series

Hi! I encountered a strange bug. I tried to create drop down list from a set of time series (00:01, 00:02, 00:03, 00:04, 00:05, 00:06, etc.) which is working fine until I type each time value in the cells manually. BUT when I try to drag down to fill in as a series, the data validation does not...

I am trying to automatically add series using VBA. I have a list of values that I want to graph and I want to see if I can automatically do it based on different values. My graph would be column K as the x-axis; column J as the y-axis and column B as my series names and pulling data from them...

Good morning! I am trying to write a If/Then formula which returns one of two statements based upon the input in an series of cells. Example: =IF(H29:K38="X","Fail","Pass") If an "X" appears in H29 - K38, I was "Fail" to appear in a cell, if "X" does not appear I want "Pass" to appear...

hi all.. how to make series number for this case : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px...

Afternoon, I am struggling to overlay a horizontal stacked bar chart I have created that already shows max and min ranges, and a break for the average values, with markers that represent a current value. I managed to do this in older versions of Excel by adding a new series, changing that...

I have a program that is on a USB drive (iso mounted on usb as .exe from an original CD- no license key needed). I'd like to have a series of macros that do the following but I have no idea how to get Excel to do much outside of the program itself. Macro1: checks system "requirements"-...

I'm currently using =IF(B1=B2,C1,MAX($C$1:C1)+1) in column C and it works fine to establish a sequential numbering, but not sure how to adjust for a new year. Data Range <tbody> A B C 1 Year Team Series 2 2018 Team1 1 3 2018 Team1 1 4 2018 Team1 1 5 2018 Team2...

I have excel and I have outlook (on the physical computer). I have a button that I made that saves/archives/quits the workbook. Is it possible to have excel make a pdf of the active page and have it email out via outlook to a series of specified emails (emails to be specified on another page in...

I have the following code that changes properties of individual data series in a chart. It's currently written to change the data series format to BEVEL style and the color ORANGE (msoThemeColorAccent6). I'd like to update it to include some logic that says, "ONLY if this is the LAST data...

I'm trying to display a second serie on the Bing worldmap, it shows series 1 (FSE) but not series 2(ASP) altough I did selected the data? Data table looks like this: <tbody> Region Country FSE ASP Europe Belgium 6 1 Europe France 26 4 Middle East UAE 8 2 Africa Morocco 6 1 </tbody>

Hello all, I am new to VBA and Macros, but want to start learning to write macros for some of repetitive duties. I’ve used the recorder but want to do more. My question is that some of my data I have to do a series of things for it to become readable then this data is imported into our system...

is there a way to have excel to only allow Fill series instead of copy cells when dragging the + sign down. For example if I input value #2 in a2 and i slecect cell a2 and drag the + (bottom right of cell) to only go to 3,4,5,6 etc, instead of copying the value #2 . If there is a way to...

I have created a pivot combo chart containing 4 series of data. I set one of these series (let's call it Series A) to a Marked Line chart type while the other series are Stacked Column type. However, if I filter the pivot data such that one of the series does not have data, therefore...

Hi All, I am trying to insert a button in my Excell sheet which adds a new row while filling the series in column A E.g F1 F2 F3 F4 I am struggling to write a code which can inset a row,copy the format (border lines) and fill the series in column A I am a first time poster so apologies if...

Hello, I need a code to read and replace the values and xvalues of a chart series, specifically the row numbers. Can someone help? By now, the code I have doesn't get the values and xvalues as msgbox is a blank. Sub test() Dim cht As ChartObject Dim srs As Series Dim sht As Worksheet Dim rng...

I'm trying to Subtotal a series of SUMIFS functions. I currently have a series of the following SUMIFS function in column G: =IF(cur_month>=G$12-1,SUMIFS(amt_Jan,dpt_Jan,$A23,acct_Jan,$B23),SUM(G15:G22)) This pulls the values from another worksheet using named ranges. At the end of column G...

Hoping someone can assist me doing this little faster using a Macro or script. I know I can type a starting number in any given cell. Then I can click Fill > Series > Select Columns and enter the Stop Value and Excel will build the series for me. I am looking for a faster way of doing this...

Hi all, I'd like to know what you all think is best way (specific details not required) to show the status of a given item over time as 3 minute snapshots. A color slot (Yellow, White, Green, Red) will be added to each interface every 3 minutes. Interace_1 YWWWWGGGGGGGGGGGGRRGGGGGGGGYWWWW...

Hello friends, Hope all is well! Please help me speed up the Loop code. The code is running OK; But too slow. Thank you so much! Sub B_REV() Dim aSeries As Series ActiveSheet.ChartObjects("Chart 9").Select For Each aSeries In ActiveChart.SeriesCollection Select...

Hi all, I have been struggling with this and i will be grateful is some one can help me. It must be done it WITHOUT pivot tables or filters, just formulas!! I have to create ranking position, where the output is the Name of the Top 3, who got the highest scores. With parameters or...