Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating an unusual chart
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating an unusual chart
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 "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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a High-Low-Close chart with multiple series? | Charts and Charting in Excel | |||
creating a percentage bar chart in excel | Charts and Charting in Excel | |||
Creating a dynamic asset allocation chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel |