series

Hello, I'm having an issue trying to bring multiple data sources with date X-axis values into the same chart with a VBa macro. The chart "scales" to the first series added or whichever is set as the source data. When the other series' are added, I think they might be unwittingly "discretized"...

Dear all i want to fill series with specific intervals for example auto fill with 2 interval auto fill with 3 interval 85 85 85 85 86 85 86 86 87 86 87 86 88 87 88 87 89 87 89 88 88 88

Hi, I work on a tool that formats Excel charts for best fit to a powerpoint template. My organisation produces projections on different kinds of topics. We make lots of graphs with dotted series for the projection period. Before copy to Powerpoint it is necessary to tweak the dotted series so...

Is this possible on excel? I have for example a file using vlook up function. source file is like this SI-1001 10 SI-1002 20 SI-1003 30 SI-1004 40 SI-1005 50 SI-1006 60 Now i need to look up this SI-1001-1004 vlook up all making the result be...

I’m trying to use the data (see images below) to have three data points for each dot on the scatter diagram. I need each series element to be custom selected data (not fixed label) so that when I hover over the dot all three data points are visible. I can do this manually; however, I want to do...

I am trying make a bar graph of the data shown below. The x-axis should be "Years" and the y-axis, should be "INCOME," "SPENDING," and "TIPS." In my attempt below, it can be seen that "TIPS" are not following the correct "Years" input. I created this graph be using the Graph Wizard in Excel...

Hi Has anyone used predictive forecasting in Excel, before? If so, your thoughts would he appreciated here: I need to answer two questions using the data below, which apparently has a predictable pattern that should be used to generate forecasts for the different food types. i) which food...

Hello! I've encountered very weird behavior of Excel after latest update (semi-annual channel). Everything was working perfectly for over a year now. I've created addin (VBA), that creates charts automatically from pulled SQL data. I used following format for series data definition: SERIES...

Good afternoon all, I'm certain that we've all had this issue at one point or another but I can't seem to find a solution--hoping that someone has something ready to go. Here's the summary: PivotChart with Date values on X AXIS and a Running Value Count 'flattens' when max is reached. The...

Good day, I have two columns of data, 1st is time and the second are values, The time column is from 4.00am to 4.00am the next day increasing by 1hour intervals, the values increase to a max and then decline in a series of highs and lows. I want to calculate the change in value meaning the...

Hello, If i have a series of numbers as per the below, how do i make the lowest value return a 0? A1 - 25 A2 - 36 A3 - 14 A4 - 20 A5 - 6 In B1:B5 i need B1 - 25 B2 - 36 B3 - 14 B4 - 20 B5 - 0 Thank you

Hi Folks, I have four column chart and the gap between series is big. I used the gap width button and the column width is increased overlap adjustment does nothing. Is there a way to bring the columns closer to each other? Thanking you, AFD

Different issue to the previous one but vaguely related. I have charts set up in XL2013 32 bit, I've now got XL2016 64 bit with secondary axis. When I select a series and click (or press) delete, that series stays but all the others disappear. Doesn't matter which axis they are on. When I...

Help! I've got a large model with 30+ charts. They were created in XL2013 32bit, I've now got 2016 64bit. When I try and amend the bounds (upper or lower) for the secondary axes, all the chart elements (series, axes, legend) disappear and I get left with a blank chart. I tried deleting the...

The chart on the right is the required version but when I include complete series values from B to F column as series data, it shows a slope at end as shown in left chart. How can I it be corrected? If it can only be corrected by limiting the series value range from B to D column like i...

My situation Brand new workbook All options checked/selected: a. Options>Advanced>"Enable fill handle and cell drag-and-drop" b. Options>Advanced>"Show quick analysis options on selection" c. Options>Advanced>"Enable AutoComplete on cells values" d. Options>Advanced>"Automatically flash fill" e...

I've got a scatter plot and when I hover over a point, it says something like: Series 1 Point "1.03" (1.03, 4.12) Series 1 Point "2.7" (2.7, 3.06) I'd prefer for it to say: Thomas (1.03, 4.12) Leslie (2.7, 3.06) I can get the labels onto the chart, the problem is when hovering the mouse...

I have been asked to spread a series of values over a set number of months that will form a data series that will produce 45 degree line when graphed. Any ideas on the excel formula to calculate the monthly amounts?

Hi all :) Very new "VBAer" :) I have Excel data as per below <tbody> A B C 1 Location Code Series Number Country 2 4000 1 Australia 3 4001 2 Australia 4 4002 Australia 5 4010 Australia </tbody> I require this result <tbody> A B C 1 Location Code Series Number Country 2...

I keep getting a "subscript out of range" error on the If statement. I've tried changing the start index to 0 and 1 and it still had this error. Sorry the codes messy, part of the reason I've been messing around with a lot of different ways to declare the array. I'm trying to alter values of...