Building Chart based on Column Value

[Greggy]

I would like my chart to show rows where "COLUMN C" = "TEAM1". Then I
can change "TEAM1" to "TEAM2" and only chart rows where "COLUMN C" =
"TEAM2".

Does anyone know how to do this?
Thanks!
Greg

 

[Ed Ferrero]

Hi Greggy,

There is a sample here http://www.edferrero.com/ReportWorkbook.zip
(Might be a bit more than what you want, but the techniques are the same)

Ed Ferrero
http://www.edferrero.com

 

[Greggy]

Ed,

Thank you so much for your reply, I really appreciate it. I created a
sample spreadsheet to better explain my request:

_|-----ColA---|--ColB--|---ColC---
------------------|-----------|-------------
1|Employee-|--Shift---|--Hours--
2|---------------|------------|------------
3|Donald-----|----A------|----20----
4|Herbie------|----A------|----16----
5|Joanna-----|----B------|----08----
6|Nancy------|----B------|----12----
7|Arnold------|----A------|----56----
9|Tiger--------|----B------|----22----

I have 3 columns: Employee, Shift (A & B shifts), & hours. How do I
have a chart use the following logic: If Shift = A, then include
employee name and hours of Shift-A in my chart.

Again, thank you for your feedback.
Greg

 

[Ed Ferrero]

Hi Greggy,

Looks like its time to learn about Pivot Tables.

Look at the tutorial here http://www.edferrero.com/tutorials.aspx

Ed Ferrero

 

[Greggy]

nooooooooo!!! ... LOL.

OK, OK. I will go through the tutorial.

Thanks much,
Greg

 

[Greggy]

For some reason the tutorial is not working.
==================================================================
Server Error in '/' Application.
--------------------------------------------------------------------------------

The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its
dependencies) could have been removed, had its name changed, or is
temporarily unavailable. Please review the following URL and make
sure that it is spelled correctly.

Requested URL: /tutorials.aspx
==================================================================

I use IE7.

Thanks,
Greg

 

[Ed Ferrero]

Hi Greggy,

Try again. Last night (Australian time), I moved the site to DotNetNuke.
Still a few problems - I am working to sort these out.

Ed Ferrero

 

[Greggy]

Still not working. I'll try again in a couple of days.