LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
QB QB is offline
external usenet poster
 
Posts: 57
Default Excel 2007 - Merged cells as data source

I am using a set of merged cells as a data source for a line chart. However,
I am getting empty/null entries as part of the data set from the merged
cells???

Basically, I have a set of merged cells each consisting of 3 cells. When I
create the data source I get values like:
73%,,,61%,,,...

Why is it making up value for each cell even though the cells are merged
together???

I am truly finding 2007 very frustrating and very counter-productive!

Please help,

QB
 
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
trying to sort excel data. won't allow. merged cells sizing.?? Skinny in the footlhills Excel Discussion (Misc queries) 1 May 25th 09 03:42 PM
Excel 2007 bug? Merged cells must be formatted as scientific CherylLynn Excel Discussion (Misc queries) 2 January 17th 09 01:02 AM
Excel 2007: Word wrapping in merged cells jgcrews Excel Discussion (Misc queries) 2 May 30th 08 06:54 PM
Excel 2007 change pivot data source bdub Excel Discussion (Misc queries) 4 August 13th 07 07:54 PM
Excel 2007 change data source Bart Excel Discussion (Misc queries) 1 October 4th 06 11:19 AM


All times are GMT +1. The time now is 09:01 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"