series

  1. 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...
  2. 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...
  3. 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
  4. 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
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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?
  11. 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...
  12. 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...
  13. G

    Advanced Graph options.

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

    Excel Line graph

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

    Fill series but end and continue with macro if series ends at "1"

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

    Data label in series stacked bar chart

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

    VBA Excel Series Of Prints

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

    Data labels not displayed correctly

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

    Data labels color in stacked bar data chart

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

    Categorize by values

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top