series

Hello, this is a bit of a new concept (for me) I'm trying to master here, so any help or pointing in the right direction is appreciated. I have a series of numbers (anywhere from 100 to 1000 unique numbers in the series) and I need to rank those numbers according to a trailing number of...

How would I go about updating the series on a chart that is currently setup like this to utilize a table? Series Name: =Harrisburg!$H$6 Series Values: =Harrisburg!$H$7:$H$146 The table is already setup and when I create a new chart from that table the data series information looks the same...

I have a graph with a table, but I want to customize what is in the table. I have 7 series that I have plotted and I want those in the table but I have also created a series in my data for the average which will be a solid line in the graph. Is there a way to remove the average series numbers on...

I am trying to filter and/or sort a data series, but it is not working. Every cell in the series is driven by a formula pulling info from other cells in the workbook, but I don't think that should be an issue because I have similar setups in other workbooks and it works fine. Any idea why...

Hi all, This one has stumped me and I can't find the answer online. I need to sum a series that increases by a percentage each period. However, the percentage it increases depends on the number of periods. I.e., if it needs to increase from 80K to 100K over 3 years, the annual percentage...

Guys - I need a formula in Sheet1 Column B. The exact matching criteria may not be in Sheet2, but it need take the series (Eg: 11 & 12) and compare with Sheet1. Hope the example below with coloring is helpful. Thanks! Sheet 1 <tbody> Series Need formula below?? (Amount) 11-00-00 3000...

Hi Forum, I have a series of data in column C . I would like to group and sort (max/min) as like column A. Can you help what formula can be used please? <tbody> A B C 10 1 9 7 8 4 7 2 6 8 5 5 4 3 3 9 2 6 1 10 1 7 4 2 </tbody> Regards, Hendric

I have entered the following dates into cells that correspond to Monday-Thursday 9/10/18 9/11/18 9/12/18 9/13/18 I highlighted the cells and dragged to fill series so that it continues the pattern and it's not working. I want to exclude Friday, Saturday, and Sunday dates. How do I get this to...

Hi, Now i got struck and need your valuable help here. I need to find the next number of a series of numerical values listed below, 505018 344936 677723 131820 198043 225002 776386 333117 544280 688659 760158 808183 487860 143137 345895 208028 224946 564152 764905 ------ ------ ------ how do...

Hi, Thanks for taking the time to look at this post. I hope I'll be able to explain what the help I need! Basically, I have a sheet with a series of tables, descending. There is a series of information across the top of each entry, including a unique ID, then some irrelevant information, then...

Hello experts... I am trying to plot a stacked bar graph with 2 series. Series 1 is positive number Series 2 is a negative number but am using ABS to convert it to positive number When i plot the stacked bar graph, Somehow series 2 is still plotted as a negative series Does anyone knows what...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I am looking special conditional formatting; perhaps it would not be possible doing by the formula. Need your help with a VBA solution </SPAN></SPAN> My series is made of three characters 1, X and 2</SPAN></SPAN> I want to highlight every...

I want to add series lines to an XY scatter plot but control which data points are connected (and not connect the whole series). I haven't found a way to do this, I'm wondering if anyone has any tricks. I know I can create separate series to resolve this, but the data categories repeat...

Hello everyone, I have a series of dates from 2013 till 2018. I'd like to count the exact days for them but they aren't in sequence. Meaning a date could start from 12 march 2013, the next one from 15...etc. <colgroup><col></colgroup><tbody> 08-Jan-13 09-Jan-13 12-Jan-13 15-Jan-13 Many...

hi all.. how to make fill series number like this : without helper column and no macro <tbody> input/entry after formula 1 1_1.jpg 2 2_1.jpg 3 3_1.jpg 100 100_1.jpg </tbody> any help, much appreciated.. m.susanto

Hello - I found this VBA that changes the data series for all of the charts in my workbook. Works great. 1. How do I change so that it only changes the charts on a sheet, and not the entire workbook... 2. Possible to also only change selected charts? Thank you. Sub ChangeAllCharts()...

hi i have made a macro code to accept an array from an excel cell. but right now i am not able to accept a value. for ex "Series 1, Episode 4 Including the 1980s story of a campaign for a hospice to be built in the Highlands." from the above example i need to accept series 1 in an array. and...

I am having this issue with Pivot Charts. I have a bar chart with about 40 series. I want the Data labels Labels options to be Series name and Value, with a line separator. I can't seem to find a way to apply this to all series. When I make the change it only changes the first series and then I...

Hopefully this is a simple one... I'm trying to set the errorbar for a chart series with VBA and I'd like to do it without actually selecting the series. Can anyone tell me why this works: Sheets("DAPReport").ChartObjects("MedianDAP").Activate ActiveChart.SeriesCollection(2).ErrorBar...

I have a series of data (c. 200k rows) with a sample below, and I'm after a formula that will give me the Min value for Start Date for each unique Item ID. I have used a formula (=days(today(),[Start-Date]) to calculate the days, but how do I identify only the min value for each of the SKUs...