View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Creating an unusual chart

That didn't look too good. Stupid rich text interface. Read this with a non
proportional font.

Arrange your data in two columns:

Month Value
Jan 1
Jan 2
Jan 5
Jan 10
Jan 7
Feb 3
Feb 5
Feb 9
Feb 3
Feb 1


Make a pivot table (Data menu). Drag the data field to the Rows area, drag
it again to the Data area. Double click on the Value field button (labeled
Sum of Value) and change the measure from Sum to Count. Drag the Month field
to the Columns area. Here's the pivot table:

Count of Value Month
Value Jan Feb Grand Total
1 1 1 2
2 1 1
3 2 2
5 1 1 2
7 1 1
9 1 1
10 1 1
Grand Total 5 5 10

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
Arrange your data in two columns:

MonthValue
Jan1
Jan2
Jan5
Jan10
Jan7
Feb3
Feb5
Feb9
Feb3
Feb1


Make a pivot table (Data menu). Drag the data field to the Rows area, drag
it again to the Data area. Double click on the Value field button (labeled
Sum of Value) and change the measure from Sum to Count. Drag the Month field
to the Columns area. Here's the pivot table:

Count of ValueMonth
ValueJanFebGrand Total
1112
211
3 22
5112
711
9 11
1011
Grand Total5510



"john mcmichael" wrote in message
...
I am trying to create a chart from a data table in Excel that has months on
the left and numbers listed horizontally across a row.

Jan 1 2 5 10 7 etc
Feb 3 5 9 3 1 etc

I would like to create a chart that shows the data with months on the left
and the numbers across the bottom and then plots points that would show me
that in Feb, I have the number 3, 2 times.

Is something like this possible?

Thanks for any advice you can provide on this very unusuall chart.