473,396 Members | 1,608 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Excel control click issue need more than 11 values

135 100+
Hey all,

I don't know where to go with this Excel question so I thought I would come here. You all have always been able to answer/help me with all my Access questions. I know this is not exactly kosher asking this in an Access forum...

I am trying to create a chart in Excel 07, I am pulling data from multiple sheets (each sheet being a year). Within each sheet is 12 different months worth of data for the corresponding year that each sheet represents. I want each series in my chart to reflect a years worth of data for each month in that year. I am control clicking to pull the specific data from the sheets. However, and here is the problem, my "series values" will not allow me to select more than 11 values (cells). When I attempt to control click the 12 value I get an error beep and the values reset back to empty in the values selector box. BUT I can select as many cells as I want if I click and drag/highlight consecutive cells. I just can't control click to select more than 11 cells... and of course I need 12 values in each series! Ahhh!!

Again, I know this is totally off topic but I'm desperate. If someone has an answer, or could tell me where I might go to find an answer or post a question in the appropriate forum I would be grateful.

Thanks!
Mar 10 '10 #1

✓ answered by topher23

I usually get around these types of problems by creating a separate "data sheet" that links to just the values I want, then build the chart off of that sheet. This gets around the ctrl-clicking and allows me to select the whole thing consecutively, since it only has the data I want for my chart in it.

4 2446
NeoPa
32,556 Expert Mod 16PB
It's fine to post this here. I just don't have the relevant experience to help you in this case I'm afraid. We do have other experts here with Excel experience though.

Good luck with the question.
Mar 10 '10 #2
topher23
234 Expert 100+
I usually get around these types of problems by creating a separate "data sheet" that links to just the values I want, then build the chart off of that sheet. This gets around the ctrl-clicking and allows me to select the whole thing consecutively, since it only has the data I want for my chart in it.
Mar 10 '10 #3
NeoPa
32,556 Expert Mod 16PB
Sounds like pretty solid advice to me :)
Mar 10 '10 #4
MyWaterloo
135 100+
@topher23
Thanks topher. I guess I was just hoping to avoid having to rearrange all my data to "fit' the chart builder. I don't understand why I can't control click all the info I want to select. Oh well, I figured I would have to just put my data in an "Excel happy" format. ;-) Thanks though.
Mar 11 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Saur | last post by:
Hi, I am using an export to excel functionality from my ASP page. I have set the content type as Response.ContentType = "application/vnd.ms-excel" The data i am exporting has values like 1-2,...
2
by: cschang | last post by:
One of my client stations using IE 6 (v6.0.2800) to open one of my page which write the records into an excel format. However, it got some strange pop-up message that I can not figure out where it...
6
by: Matthew Wieder | last post by:
I have the following requirements: Build a stand-alone C# application that asks the user to click in a cell in an Excel spreadsheet, and then displays the address of that cell in the C#...
14
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...
6
by: Rich Wallace | last post by:
Hi all, I have a VB app that runs and manages individual XLS files within a single COM object. Upon processing the final fie, I attempt to close out the EXCEL object and release it using...
3
by: Marja Ribbers-de Vroed | last post by:
Hi, One of my clients has a strange problem with my webapplication which I think may be related to some firewall setting on his computer. On several screens in the application, it is possible...
1
by: SHANE CLARK | last post by:
I have a question...I am attempting to write the values of multiple textboxes to an MS Excel spreadsheet. I would like to be able to write the values to let say a1,b1,c1,d1...ect and then click on a...
4
by: Frank | last post by:
Hello All, I ham using VS.NET 2003. Have followed instructions from http://gridviewguy.com/ArticleDetails.aspx?articleID=26 along with several other articles to no avail. I am pulling my hair...
16
by: alexia.bee | last post by:
Hi all, In some weird reason, excel instance won;t die if i remove the comment from 4 lines of setting values into struct. here is a snipcode public...
4
by: Henry Stockbridge | last post by:
Hi, I am using Access 2003 to automate an Excel workbook, but after the code completes Excel does not quit (at least it is still listed in Task Manager --Processes.) I have set a reference to...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.