1. V

    Chart series date misalignment depending on source data

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

    auto fill with specific interval numbers

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

    VBA Excel - Charts - how can you determine if a line series is dotted or dashed

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

    vlookup function

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

    using data to create the series label in Excel on X Y Scatter

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

    Making a Bar Graph from Unsual Data Format

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

    Excel forecast

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

    Using listobject name reference in chart series issues after update

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

    PowerPivot, Running Totals, and Chart Lines with null data

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

    Min and Max in sequence

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

    Make the lowest value a 0

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

    Excel chart series gap

    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
  13. Johnny C

    XL2016 When I delete a series that series stays and the rest disappear?

    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...
  14. Johnny C

    Chart series disappear in XL2016 when secondary axis changed

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

    Area Chart Problem

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

    Fill Series greyed out...

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

    How do I get a label in a scatter plot instead of "Series 1 Point"?

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

    Calculating data series values to form a 45 degree line

    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?
  19. J

    VBA - AutoFill Series

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

    Subscript out of Range every time?

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back