series

  1. H

    Categorize by values

    I am doing a project timeline chart in excel. I have 3 series in stacked bar chart.The categorization of the series is based on the first two columns of the chart. The fourth series is just displaying the data label. All the three series in the chart is the difference between the different...
  2. M

    Charts won't maintain series color when only changing values with VBA

    When I attempt to use the following to update series values using an array, The series don't maintain their coloration and defaults to one of the available presets. With Chart_Dictionary.Item("Non-C").Chart For L = 1 To 4 .FullSeriesCollection(L).XValues = Date_Range...
  3. T

    Mac Excel Chart Help Adding Second And Third Series

    I'm building a chart from 3 series of data. Mac Excel 16.16.12 The issues: Adding data series 1 is all ok and called "Series 1 "Point A"" on the chart. All category names on X-axis are correct. Adding series 2 is ok and called "Series 2 "Point B"" on the chart; however, "Series 1 "Point A""...
  4. T

    New data series changes data in old series Mac Excel

    I'm building a bar chart using 3 separate series on Excel Mac 16.16.12. Creating the chart from series 1 is ok. Adding series 2 creates an issue in that it alters the data in series 1. Description of issue: The original chart has "Series 1 Point "A"". I add a second series and the second...
  5. L

    Export Excel chart to pdf with layers

    Hi Everyone, I was curious if anyone knew of a way to export an excel chart to PDF of which will include a layer for each data series. The ultimate goal is the ability to send a client a series of charts which they will be able review and turn on/off the different series, some of which overlap...
  6. S

    Fill series in formula going column direction

    Hi, I'm trying to copy data from sheet2 into sheet1 using the following formula ='sheet2'!$A1 and then dragging the formula all the way to column Z. I want to keep Column A the same but have it automatically fill the series of A1, A2, A3, and so on but it doesn't do that. Instead it'll copy...
  7. N

    Time series

    Hello, I have a set of data which I am trying time series. Can anyone help me with the vba code? The current macro creates the first event with the last business date but I want it to replicate the lines below but only update the dates current date. If last business day is Friday and I am...
  8. V

    VBA: Custom Data Labels Question

    Hi, I am trying to apply custom data labels to my chart from a series. This is the relevant section of my code. ActiveChart.FullSeriesCollection(2).Select ActiveChart.SetElement (msoElementDataLabelCallout) ActiveChart.FullSeriesCollection(2).DataLabels.Select...
  9. A

    Pivot table with 3 value series Double-click summary

    Hi, I just got caught out on something I haven't encountered before and I'd like to know if there is a proper solution or just the workaround I can think of. FYI I am joyously working on Excel 2010. I have a pivot with 3 series of values. However when I double click on any one of the totals it...
  10. J

    Dynamic Data Series Scatter Chart

    I have a scatter chart that I want to change based on the Table heading chosen in a Drop down Box. I have followed all the posts suggesting using name ranges but nothing seems to be working. This is what I have so far: <tbody> <colgroup><col><col><col></colgroup><tbody> GRAPH X SERIES (INF)...
  11. V

    VBA: Find coordinates of markers on chart and attach a textbox to them

    Hello, I have a 2 data series. The 2nd data series only consists of points that I want shown on the first data series. So I have a price and date series with markers showing up only on specific dates. I would like to attach text boxes, or place text boxes, near those markers. I figured one way...
  12. V

    VBA: Add symbols to graph based on position of data series?

    Hello, I am trying to add directional arrows. I have a data series in my chart that is essentially 2 vertical lines and I want the arrows to point to those lines. Is there anyway to set the position in vba based on that vertical line series? This would have to be something that automatically...
  13. V

    VBA: Adjust y-axis scale based on 1 data series

    Hi. I am making a chart with multiple data series. One of them is a fake series that I use to shade so the values are way higher than the normal series I use and excel accounts for that when auto scaling. Is there anyway in VBA where I can specify which data series to base the auto scale? Thanks.
  14. S

    Data validation problem

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

    Macro to add Series on Graph

    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...
  16. D

    If then statement covering multiple rows and columns

    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...
  17. muhammad susanto

    Fill Series Number Based On text

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

    Max Min Average Stacked Horizontal Bar Chart with Current Markers Overlay

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

    Excel to Check System settings/requirements

    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"-...
  20. F

    Create numbering sequence within groups

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top