series

Hi, I'd like to be able to plot multiple data series on the same graph with the same horizontal axis. I have sets of data including metrics like temperature, pressure, distance, height, speed etc etc all of which have the same horizontal axis (time). The problem is that all of the metrics...

I am looking to plot a line graph with upper and lower limits (Ranges). Attached is the target view (PNG). The value that I have, has positive and negative values. Hence showing upper limit and lower limit range in the line chart is a bit complex. Attached is the excel sheet(Sample.xlsx) with...

Hello, I have a vba code that will fill a series from A11 down however if there is only 1 item (A11) I need something in my code that will recognize this and not give me an error but continue with my macro. What could I add to this line to have that happen? ActiveCell.FormulaR1C1 = "1"...

QA Series : Difference between two columns ( QA Start and QA End) MFG Series: Difference between two columns ( MFG Start and MFG End) LGS Series : Difference between two columns (LGS Start and MFG End) 1) If there are values only for the GO SALE column, the values getting displayed only at...

Good afternoon I have a a VBA (EXCEL) which looks across columns and rows then prints a series of sheets accordingly what happens is a preview window pops up I still need the selection of a printer but would like then to print with no interference

I have a 3 series stacked bar chart and the fourth series is a data label. The data label is a date value that selects values from the date column. The Primary axis is categorized based on 2 values. The secondary axis is Month. The data labels are displayed accurately as per the month except the...

I do have 3 series in a stacked bar chart. The fourth series is a data label displaying the date. I need to display different color for the label based on a column that as Yes or No values; ie., display data labels in red color if it satisfies Y and display in green if it satisfies No. How to...

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

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

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

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

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

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

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

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

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

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

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

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

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.