View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
svt4cobra6 svt4cobra6 is offline
external usenet poster
 
Posts: 1
Default new to excel 2007 how to chart this data

Hi I have some data with the first column as simply the item #. I want this
to be the x axis of my chart. The first series I want to chart is in the 4th
column and is hours for each item. I would also like to add another column
to the chart, the 8th column and it contains a string, pass or fail. Any
suggestions on how to chart this? I tried creating a pivot chart but after
selecting the all the columns and then secelcting insert pivot chart, nothing
shows up for the section that allows for data selection.
Thanks.