series

  1. S

    Excel to email PDF page of spreadsheet

    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...
  2. A

    VBA for "if data series is last series in the chart, change the color of that data series"?

    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...
  3. B

    Adding second serie on Bing Map in Excel2016

    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>
  4. V

    VBA for Data Manipulation

    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...
  5. H

    Fill Series as default when drag-n-drop

    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...
  6. M

    Pivot Combo chart - retain chart type for specific data series

    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...
  7. A

    Insert Row and fill series from one column only

    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...
  8. J

    VBA replace Values and Xvalues in charts series

    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...
  9. Z

    Subtotal & sumifs

    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...
  10. I

    Macro to create series of number using a start and end number

    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...
  11. J

    How to chart an item's status with cumulative color codes over time with updates added every 3 minutes

    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...
  12. countryfan_nt

    Speeding up the Loop code.

    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...
  13. S

    Top 3 Rank , extracted from DB

    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...
  14. L

    Macro to enable/disable chart series

    Greetings: Running Excel 2013. I have created an x-y scatter chart with a dozen-plus series to show time evolution of my data. I can right-click on the chart, select "Select Data" and manually check and uncheck the appropriate series. However, it's time consuming to go through the repetition...
  15. O

    Closest Sum to a Given Number

    Hello, I am trying to create some type of formula or VBA script that will look at a series of given numbers and identify which numbers if summed together are closest to another given number. For example if I am given the series of numbers shown below, which numbers if summed together are...
  16. G

    Lock a range of cells when an entry is made in another cell

    Hello all, I have a spreadsheet that has a cell that when one answers a series of questions a value appears in that cell. I would like to lock all of the questions after the answer appears. Any suggestions? Thanks.
  17. A

    Auto fill serial number with Macro (Situation question)

    Hi guys, me again, a VBA beginner. I have the information below:- Column B1:E1 are the description. Then we copy the data from other sources based on these description (FilexxNAME, Nature, Place, Tool). We dunno the total number of the series. It can be 6 series (like example below), or it...
  18. A

    More than 255 series in a chart (sort of)

    Hey guys So i know that 255 is the maximum number of series that excel can plot. However would excel be able to plot more than 255 series on a graph but only having 7 or so displayed at one time? I am trying to make a dynamic chart that changes what series are plotted based on different...
  19. H

    Problem with Peltier Technique - stacked charts

    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...
  20. M

    VBA for stepwise process involving dialog boxes with fillable fields

    Hi, I will preface this by saying that I'm new to VBA. I'd like to write some code for a command button that will complete a series of actions and then create a series of dialog boxes with fields that the user can then type in, and then when you close the final dialog box, all of those things...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top