LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 24
Default Creating a Simple Bar Chart - 2 Areas for help please

I've got 2 columns of numbers - column A is a continuous set of integers
going from about 40 to 210; column B is a frequency count going from blank
up to 10. A sample is shown below.

PROBLEM 1

Using XL2007 I can't even seem to get a simple bar chart showing frequency
count (y axis) against number (x axis). I just get either a total as a
single bar or a cumulative count.

PROBLEM 2

Once I've got this working I'd like to be able to group those numbers (eg
into 5's or 10's) so as to reduce the length of the x-axis

Can SKS help out please.

Tx




44 2
45
46
47 1
48
49 1
50
51
52 2
53 2
54 5
55


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Aligning two chart plot areas - simple but tricky! Alseikhan Charts and Charting in Excel 1 March 20th 06 11:47 PM
Calculate areas from a cross section chart?? nated7777 Charts and Charting in Excel 1 February 18th 06 02:54 PM
How do I set my Excel Chart to not show areas where I have no dat. AmyJ Charts and Charting in Excel 1 January 14th 05 09:45 PM
highlight areas of chart? Stan Altshuller Charts and Charting in Excel 1 January 14th 05 09:43 PM
how do allow two charts with two different chart areas? Omar Charts and Charting in Excel 1 December 8th 04 01:05 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"