Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Horizonal category axis

I want to take the years that are in cells B3-F3 and put them on the
horizontal axis.
The directions say to edit the data source so that horizontal category axis
uses the years in range B3:F3.
Can someone help me? Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Horizonal category axis

Typically, when you are setting up the range to be charted, the top line, in
your case row 3, contains data for the horizontal axis, then the data follows
in contiguous rows/cells, row 4 and below contain the data to be plotted. If
your years are in a separate section of the worksheet it is likely not to
work. If the data is not contiguous use the control key to highlight the
sections. The highlighted sections must form a rectangle, e.i. line up.

See the help section on creating charts.

"formulaconfusion" wrote:

I want to take the years that are in cells B3-F3 and put them on the
horizontal axis.
The directions say to edit the data source so that horizontal category axis
uses the years in range B3:F3.
Can someone help me? Thanks

Reply
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
Horizonal bar chart with secondary axis problem BZ Charts and Charting in Excel 1 June 4th 09 08:14 PM
Chart templates treates value axis as a category axis FHW at EAD Charts and Charting in Excel 3 December 17th 08 03:19 AM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 08:45 PM
Adding data on Axis Major Gridlines next to Category Axis Collums jblittlejohn New Users to Excel 0 July 10th 05 12:17 PM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM


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

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

About Us

"It's about Microsoft Excel"