Charting

Resolved · Medium Priority · Version 2003

Charting

Leon has attended:
Excel Intermediate course

by - delegate Leon [1 post] (2008 Jun 18 Wed, 17:13) Reply

How to chart bar charts with data that varies eg one variable has large number eg in 100 of thousands & the other variable has decimals & you want to format the scale to see both?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Charting

by - trainer Amanda diamond contributer [1208 posts] (2008 Jun 20 Fri, 11:50) Reply

Hi Leon

Thank you for your question; and welcome to the forum.

If you wish to represent both the numbers and decimals as columns in the chart, then this isn't easy.

There is a work around that you can try by modifying the data that the chart is created from, which is outlined on the following web page:
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

I would recommend using the Chart toolbar to select the series that aren't visible rather than using the keyboard to do this (View>Toolbar>Chart).

The primary and secondary axes referred to can be accessed by selecting the series you wish to work with, and clicking the Format Data Series button which is the first button from the left on the Chart Toolbar. You will find that there is an Axis tab within the options presented.

Good luck!
Amanda

· Basic Excel Training
· How to Create Better Excel Spreadsheets: Part One
· Excel and Inventory Management
· Identifying Suitable Candidates For VBA For Excel Training
· Benefits of learning about Excel charts

Please browse our web site to find out more about
excel+course and other Microsoft training courses.

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips