sourcing multiple worksheets for a chart

spakole

Board Regular
Joined
Sep 13, 2005
Messages
50
I am trying to create a chart that sources data from multiple worksheets within the same workbook. All the cells are the same location in each worksheet.

I keep getting an error message on the formula entered under the value box.

='Aug 05:Dec 05'!$BA$111

This formula kicks back an error highlighting 'Aug

I have tried different variations of this formula, but nada.

What am I missing?
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

sweater_vests_rock

Well-known Member
Joined
Oct 8, 2004
Messages
1,657
spakole.

i see the shortcut that you are trying to use, but excel doesn't recognize groups of worksheets in the same way it recognizes groups of cells.

if you want to create a chart from multiple worksheets, you'll need to enter data series by series (right-most tab in the source data wizard) as opposed to by data range.

hope this helps. ben.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,033
Messages
5,569,777
Members
412,291
Latest member
marypolitan
Top