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

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

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.

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

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

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

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

Hi all, I need to generate date series in columnar form for many of Bond series from the date of purchase till Maturity date. I do not want to use fill handle as for all bond series i can not use. Following is the required sheet; <tbody> Name Buy Date Maturity Date Year Left Year 1 Year 2...

Hi Having an issue that I don't remmeber encountering in the post. I have an array of data where I am using IF and ISERRROR to return "" if the data point is not available. I've tried making the data return "na" as well as "-" and having the same issue where when charting the data series those...

Hello, I have simple data that I wish to chart in Excel. The format is as follows: 2018.08.06 18:00 7441 7442.5 7439.8 7440.2 2018.08.06 18:30 7440.5 7442.4 7439.8 7441.8 2018.08.06 19:00 7441.9 7443.7 7440 7442.2 The first chart I posted showed the time as well as the...

I have a surface contour plot as a chart sheet. I need to be able to modify the number of series (20-200) and the number of data points in a series(200-1200). Do I have to do this one series at a time or can I just specify the rectangle that contains the data?

Hi everyone. Got a small problem I'm really struggling to get my head around. Is there a VBA code that lets me take the active cell and extend the series to the next cell on the right, just like you'd do with your mouse manually as shown in the following picture: <a...

I have charts generated in VBA. The chart output creates a data series that is something like "worksheet!$A$10:$A$40". I would like the chart data to be reversed so that the first value on the chart is $A$40 and it goes to $A$10. Is there anyway I can do this? I am using the code below to...

When selecting Source Data for a chart in Excel there's a "Chart Data Range" field. But in the "Legend Entries (Series)" there are also one or more series ranges. What is the point of the "Chart Data Range" if you have to explicitly define the series ranges anyway? If there are some columns in...

Display the missing number in number series. Ex : Colum 1 1 2 3 6 7 8 Missing number is 4 & 5 that will display in Column 2 like; 4 5

I am working on constructing charts with VBA within a For loop. There are two main problems I am facing. The first iteration generates a chart with five data series despite my intention of including only two. One is a multiple range source, and the other two are 1 values. On the second...

Hi, I am trying to make a sunburst chart using this chart option in PowerPoint 2016 - however I am unable to rotate the series around. For example in the chart in the attached file, how do I rotate the 1st, 2nd, 3rd and 4th series horizontally to align with the overall slide? Any help would be...

Hi, I'm following Microsoft Virtual Academy's Excel tutorial and I've come across different ways to use the fill series and I wanted to ask how you can do a fill series if you wanted to do odd days/months (so Monday, Wednesday, Friday or months Apr, June, Sept). After writing April, June and...

I have a Chart with 10 Series. For one of the series (Series 9) I want to pass the values using an array. I have created a SUB but I am unable to execute it, and can't figure out the reason. There are two charts in the Sheet. Chart1 and Chart2. I want to pass values to Chart1. Error that I am...

Hello, I have a scatter graph that contains one series and the data is located in a large table ("Format as table"). - I need to break down the contents of the graph into multiple series based on the contents of one column. Can I use some kind of “if” statement to minimise configuration and...