If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create chart with significant data in a column
I would like to create a chart in excel with data in a column but only want
the significant data used. For example, I have two columns - one with names and the other with values ranging from 0 to 10 (the cell is blank). The colums are long. I want a chart from these columns that only uses the cells that have values in larger than 5. Is there a way to do this without me going through the data and only selecting the appropriate cells? An even better solution would be to reference a different cell for the minimum value to use. thanks |
#2
|
|||
|
|||
Select your data, go to the Data menu, select Filter, then select Autofilter. In
the new dropdown above the column you want to filter, choose Custom, and in the left box choose Greater than, and in the right box enter 5. The autofilter hides the rows that are not greater than 5, and by default the chart will only display values from visible cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ jdarmstr wrote: I would like to create a chart in excel with data in a column but only want the significant data used. For example, I have two columns - one with names and the other with values ranging from 0 to 10 (the cell is blank). The colums are long. I want a chart from these columns that only uses the cells that have values in larger than 5. Is there a way to do this without me going through the data and only selecting the appropriate cells? An even better solution would be to reference a different cell for the minimum value to use. thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reversing Sign on Column of Data (Positive to Negative) (Negative to Postive) | M Stokes | Worksheet Functions | 1 | April 26th, 2004 04:33 PM |
create data point line in a column chart | Annie | Charts and Charting | 1 | February 20th, 2004 04:07 AM |
force graph to axis of choice | bbxrider | Charts and Charting | 2 | February 12th, 2004 09:51 PM |
can I hide a series in a stacked bar chart but keep the series in the data table | Stephen Bullen | Charts and Charting | 0 | December 5th, 2003 10:53 AM |
Need to create a bar chart with variable column widths | Li | Charts and Charting | 1 | November 18th, 2003 06:03 PM |