Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Filling a list box using a range

Posted on 2014-04-06
4
Medium Priority
?
265 Views
Last Modified: 2014-04-06
Folks,
In the attached workbook in the Menu tab I have a lit box under Category. Filling this list box uses a Range from the Topics worksheet (AZ). The list box also populates the text box next to it. My problem is that I can only list 10 categories although I have more. I have not figured out what is wrong on why I cannot add more that 10 categories?
Charting-Data-in-Excel-2010-Revi.xlsm
0
Comment
Question by:Frank Freese
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 2000 total points
ID: 39981715
I see 14 (Column, Cylinder, Cone, Pyramid, Line, Pie, Bar, Area, Scatter, Stock, Surface, Doughnut, Bubble, Radar)
0
 

Author Comment

by:Frank Freese
ID: 39981738
Do they appear in the list box?
0
 

Author Closing Comment

by:Frank Freese
ID: 39981743
thank you - I see them now also.
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39981741
Yes.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question