data points

Hello. I am trying to create a line graph that shows the change in pressure, rpm, and flow rate over time. I've been trying to use the graph tool that Excel has, but I am not getting what I want. Any help or suggestions would be appreciated. I have attached a snippet of the info I am trying to...

I have attempted to attach the mini sheet below with a Data Input table in which I have created. All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc. The cells in the ticks column is a manual entry...

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

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

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

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

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

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