excel programming vba - Bar charts

The UK's most regular instructor-led training courses.
Training information: excel programming vba · Excel training course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Bar charts

Michael has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Michael [1 post] (2006 Dec 1 Fri, 18:07) Reply

how do you create a floating bar chart, i.e. a chart where the range of values exceed zero thus the 'bar' is in fact floating as opposed to 'seated'?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2007	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 17 Fri	Southwark	4	book now	£224	£235
2003	2008 Oct 22 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 22 Wed	Bayswater	5	book now	£195	£205
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: bar charts

by - trainer Richard platinum contributer [812 posts] (2006 Dec 4 Mon, 09:36) Reply

Generally if you are charting data that has negative values, the wizard will include this and create a Y-axis that accomodates the lowest value. You can also force the Axes by modifying the properties, just specifiy the max, min and intevals.

Does that answer your question?

· Tools From Advanced Excel Courses: Goal Seek and Solver
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· How to Create Better Excel Spreadsheets: Part Four
· Reasons Why VBA for Excel Training Fails
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips