New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Plot data based on criteria

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Plot data based on criteria

Postby edelcol » Mon Jun 13, 2016 11:49 am

Hello Excel users,

How would you create a chart that only plots certain criteria.

Example:

Column A
Jan 1
Jan 2
Jan 3

Column B
Sales area 1
0
0
1

Column C

Sales area 2
3
5
8

Column D
Sales area 3

4
2
9

I'd like to plot on a line chart only the columns that have a daily average of 'x'. I.e. in this example greater than 1 - so area 2 and area 3.

How would you go about this?
  • 0

edelcol
Rookie
 
Posts: 1
Joined: Jun 13, 2016
Reputation: 0
Excel Version: 2010

Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 56 guests