data points

  1. C

    Label specific datapoints "n/a"

    I have the data and the chart shown below and I'm wondering how I can display only certain data labels? Basically, the first three companies are all n/a for sales (ignore the EBITDA columns) and so i want to label those as n/a. I tried creating a 2nd data set in column D and charting that, but...
  2. J

    Super easy issue, whose answer is confounding me! Remove data points' outline...

    I'm trying to format my data series in a chart, and each point is outlined with a black or grey, and the points are filled with the color I specified. Where can I specify no stroke/outline, or change its color? I've searched and can't find this darned [hopefully EASY] answer! Thanks so much...
  3. R

    Changinf cell values by moving chart data points

    I have a line chart with markers, i would like to be able to move the markers and change the cell values they refer to. I googled it and found something on this board :Moving a line chart data point revises data table value in Excel ' - ExcelBanter They said the functionality did exist but was...
  4. R

    What formula to use when data points change in a range

    Hello everyone. I hope someone can help me with this issue: I have a pivot table from cell A4..M140249 (yes 140K rows :(). I would like to create a formula that at the end of the table in column N will see where there are values in the rows, and then refer back to the header and substract...
  5. D

    Automatic colour coding for bubble chart data points

    I'm working in Excel 2007 and have created a bubble chart. I've automated the x- and y- axis data, bubble sizes and data labels, but I also want to automatically colour the bubbles either green, red or yellow depending on a text-based criteria (e.g. "strong" = green, "medium" = yellow, "weak" =...
  6. J

    Way to tally percentages of data responses *down* columns?

    Hi, I recently had asked about doing counts across rows, and got a beautiful response that worked perfectly. (see below) How I'm wondering if I can do it going down columns, and providing the count and the percentage of the total data points in that column. Is this possible? Thanks so much...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top