Inventory Labels

Your browser version will no longer be supported as of April 2018. Please upgrade to a newer version.

Monthly Specials, New Products, Overstock

CareerListings, CompanyCulture, Benefits

Creating multi-series Bubble Charts in Excel

Bubble Charts are a great way to visualise data that has three numerical values for each point. Two of the values are plotted on the X and Y axis, while the other is represented via the diameter of the bubble.

Excel also supports Bubble Charts with more than one data series this is useful if you want to label each bubble. However Ive found that the Excel teams collective brain operates in an entirely different way to mine, resulting in some very strange interpretations of my data.

For example, heres a simple table with 4 data series, each containing 3 values:

To me, this looks like a perfect range of data from which to create a Bubble Chart. However if you select the range and choose Insert Charts Other Charts Bubble (Excel 2010 menus, may differ in other versions) youll get this monstrosity:

Its possible to get more sensible results by adding each series one-by-one, but this is time consuming and useless if the number of series changes over time. There may be some way of structuring the source data to appease Excel, but I since I needed to create a bunch of charts and already had my data in this format I decided to brush off my VBA skills and teach Excel my way of doing things. The result from the same data is much more pleasing:

The VBA to achieve this is below. Note that the macro requires that you select a range with exactly 4 columns and at least 2 rows (a header row and at least one data row)before executing it. Its a bit quick and dirty, and styles the graphs according to my personal requirements, but hopefully it will be of use to others too.

PublicSubCreateMultiSeriesBubbleChart()IfOrselection.Rows.Count 3)ThenMsgBoxSelection must have 4 columns and at least 2 rowsExitSubEndIfDimbubbleChartAsChartObjectSetbubbleChart = ActiveSheet.ChartObjects.Add(Left:=selection.Left, Width:=600, , Height:=400) bubbleChart.chart.ChartType = xlBubbleDimrAsIntegerForr = 2Toselection.Rows.CountWithbubbleChart.chart.SeriesCollection.NewSeries ==& selection.Cells(r, 1).Address(External:=True) .XValues = selection.Cells(r, 2).Address(External:=True) .Values = selection.Cells(r, 3).Address(External:=True) .BubbleSizes = selection.Cells(r, 4).Address(External:=True)EndWithNextbubbleChart.chart.SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis) bubbleChart.chart.Axes(xlCategory, xlPrimary).AxisTitle.Text ==& selection.Cells(1, 2).Address(External:=True) bubbleChart.chart.SetElement (msoElementPrimaryValueAxisTitleRotated) bubbleChart.chart.Axes(xlValue, xlPrimary).AxisTitle.Text ==& selection.Cells(1, 3).Address(External:=True) bubbleChart.chart.SetElement (msoElementPrimaryCategoryGridLinesMajor) bubbleChart.chart.Axes(xlCategory).MinimumScale = 0End Sub

I can see that you provided with an excellent representation chart, dedicated for a very vital factor in project management (Risks).

Actually I expected to face couple of issues, but it worked wonderfully.

Next, Ill share this article with Excel Lovers Group (if you dont mind of course).

Many thanks for your generous gift of this code. A quick question: How would I amend the code if I have multiple data points that share the same name? For example, lets say multiple data points that correspond to a smaller number of regions in a country.

Just wanted to know if you got a reply to your questions related to multiple data points that share the same name?

This is very helpful. Thank you for posting.

Thanks so much for putting this code on the web

My brain thinks the same as yours (not Excel team ) and I was stuck till I found your post

Wording Ideas

In all thelabel designsyou can add lines of text to make the label even more personal. Have a look at the list of Personal Facts below and how to translate them into wine speak (ie something which might appear in a wine description). These are just ideas, its really up to you what you put.

(often eats at Romarios Restaurant)

(makes great cakes or top chef etc.)

Blended with the Susan grape variety

Has also produced the Tom & Lucy varieties

Best served when celebrating a win at golf

Best served when celebrating a victory for Arsenal

Best served whilst watching Formula One on TV

Often served (or often drunk) in The kings Head

Best served relaxing under The Algrave sunshine

Best served whilst listening to Neil Diamond

Guaranteed to hit the right note every time (on a guitar)

A favourite with members of the Womens Institute

It perfectly complements Fish and chips

Often served at Romarios Restuarant

Perfect with cakes or the choice of leading chefs

Best served whilst watching Eastenders

See below how the same label design can be used for lots of occasions.

Product OL194 – 22609 x 19582 Labels

HomeLabels on Sheets OL194

Calculate thermal ribbon usage for this product

Continue shopping by:SizeMaterial & ColorCategory

Product OL194 – 2.2609 x 1.9582 Labels

Weatherproof Silver Polyester Laser

The white gloss inkjet material will produce photo quality results when used with an inkjet printer. This material has a bright white, high gloss shine to it.

Weatherproof Silver Polyester Laser

Click here to enter a quantity not listed below.

Click here to enter a quantity not listed below.

– Ships the same day if placed before 5:00 p.m. EST

Please select a material from the list.

Please select a material from the list.

– Ships the same day if placed before 5:00 p.m. EST

Please select a material from the list.

Please select a material from the list.

Please select a material from the list.

We can fulfill orders of any size on in-stock products – no quantity is too big or small.

If you find a similar blank label product at a lower advertised price, contact us and well beat it.

Place your order before 5 p.m. EST and your in-stock items will be shipped out the same business day.

Free for customers, Maestro Label Designer is 100% compatible with all Online Labels products. With no installation necessary, weve made designing professional-looking labels easier than ever.

Viewable using Adobe Acrobat Reader. Template can be used in graphic programs such as Adobe Illustrator, Quark Express, and several others. If you plan to print out the template you need to uncheck fit to page in the print options or the image will be smaller than actual size.For customer reviews of Adobe Illustrator pleaseclick here.

For use in any version of Microsoft Word. This is the traditional Portrait orientation template.For customer reviews of Microsoft Word pleaseclick here.

I have had several orders placed. The company is very professional and efficient. Im very pleased with their products and services. This company receives my highest recommendation.

GREAT company. Great products!

Im so happy Ive found Online Labels. Their labels are high quality and the service is very prompt. The labels for my small business look professional, resist fading and do not smear. Great products!

I love . Im a small business owner footing the bill for everything I buy and when it came down to purchasing labels, Im glad I found them. Their labels are the best and they always put in a little extra. I really appreciate their great customer service and I will always buy from them.

I have ordered a few times and I can say OnlineLabels has the best sticker label quality out there! Ill definitely be returning for new orders soon! Thanks OnlineLabels!

As a customer I appreciate the extra mile, the fast shipping, the attention to detail; all wonderful marks of a great company! And as a small business, I aspire to achieve this level of service and commitment. Thank you for your excellent service, I highly recommend this company!

All I can say is amazing! Order my labels and the next day they are at my house! Love that there are so many options too!! Plus the price is great too and I am in Canada!

I have ordered from Online Labels several times over the past two years and have always been very satisfied

Online labels is my only source for labels because of their excellent customer service and fast shipping.

Our company just started using OnlineLabels and absolutely love their passion and dedication to supplying us with all our labeling needs. They are suuuuuper friendly people and shipping is fast and painless. The entire experience is amazing, from the blog ideas, the easy ordering and shipping, the customer service, and the maestro label designer. Cant ask for anything more! Thanks OnlineLabels!

Have been using m for about a year and each time my labels are delivered so fast I use Maestro label designer with many different labels and everything I am amazed how perfect everything lines up. Will continue getting my labels from OnlineLabels.com for many years to come.

I am a new customer to OnlineLabels. I have experienced the fastest and most prompt service ever! OnlineLabels will always be my number one go to company for ordering labels.

The turn around from order to delivery is great! Easy to use order form, and the templates are great.

Online Labels knocks it out of the park every time. Items I order are always in stock, always ship as expected and the quality for the price is amazing!!!

Great variety, quantity options, prices, and overall good quality. Maestro Label Designer saved me. I had to print barcodes and tried so many other systems, but none worked for me. The Maestro system is so easy Ill be a dedicated repeat customer just for that!

Amazing company! I have been ordering labels from this company for our Childrens Ministry for over 2 years. If you need an unusual label shape, size, color or even a clear label this is the company for you. The labels are reasonable and of good quality. The variety gives me the freedom to print our own stickers for many projects and crafts, at a considerable savings to our ministry. I also love the free access I get to Maestro Label Designer with each order. Everything considered, its a great company.

I recently opened a small business selling all natural bath and body products. I have several different products with different scents, and it was difficult finding affordable labels. I was glad to find onlinelabels.com where I can print them as I need them. I can have professional looking labels at a moments notice, for mere pennies each. Thank you Online Labels!

I have just received my 4th order from online labels and I must say the timely service is 2nd to none. all products have worked well for my projects. dont think Ill be buying any place else from now on. Good company to do business with

I have been ordering labels from Online Labels for my small business for about 3 years now. The ordering process is super simple and I can rely on my packages to arrive quickly without error. Their customer service goes above and beyond of what others try to achieve. Thank you for being such a great company!

I have been ordering labels for my office for years through onlinelabels.com. Always smooth and efficient and fast delivery. Recently, I ordered the wrong label size label – and they were very easy to deal with. Got a real person immediately, who helped me through the return process. They quickly credited our credit card up receipt of the returned labels.

As a new business owner, I understand the importance of good customer service, reliability, & products we can count on. Online Labels has surpassed my expectations. Their products, services & super fast shipping place them above their competition. I highly recommend them….you wont be disappointed!

Online labels has been great to work with. No pressure sales, easy on access, variety of color, size and material. Fast turnaround once order is placed. Ive been a customer for years and plan on continuing.

Excellent quality and amazing customer service. It makes a huge difference ordering from a company who truly cares about their customers. Keep it up, guys! You rock!

I have always received great service and great products from this company. I am really glad I found them!

We have been using online labels for over 5 years. Ours are used in packaged food that needs to be kept frozen. They are very durable and the ink doesnt smear! Re-ordering is also a breeze. Thanks!!

The ease of re-ordering your products is outstanding. Not only did I find just what I was looking for quickly, but now I can place repeat orders with just the click of a button. Great job!!!

My company has been buying labels from Online Labels for several years. We receive our orders very quickly. The customer service reps are very helpful if we cant find what we need, or if we need an order rushed out for next day delivery. I would definitely recommend Online Labels.

Ive worked with Online Labels for 2 years and have been very happy with my labels, Maestro Designer and with the great customer service.

I have been ordering labels from Online Labels for several years now. Not only do they have every kind of label imaginable but the quality of the labels is unsurpassable. In addition to a great product, I always receive my labels in a timely manner. Thank you Online Labels for always exceeding my expectations.

I am a longtime customer and rely on Onlinelabels products to be quickly at my door. They never disappoint me! Thank you for your great product, extensive selection, and reliable delivery! :O)

Since we switched to Online Labels from one of the brand name products, we are loving it. The free templates that is offered by Online Labels are easy to use and make our products look neat.

Subscribe to the OnlineLabels.com newsletter.

Receive the latest news, product announcements, and inspiration.

An email has just been sent to confirm your subscription request.

Brown Paper

Access to the R.V. PACKAGING Web-site requires a more recent Internet Browser that supports frames. The latest version of Netscape can be downloaded free of charge by clicking on the icon below.

Welcome to the R.V. Packaging website. R.V. Packaging is a major supplier of all types of packaging products to the South African market. Below is a brief list of some of the products that we supply. Please send us email if something you require is not on our list and we will confirm whether we can supply you or not. Packaging Tapes & Dispensers, Gum Tape, (Plain & Printed) Plastic Strapping, Steel Strapping, Brown Paper, Corrugated Boxes & SFK Rolls, Staples & Stapling Machines, Plastic Bags (Plain & Printed), Recycle Tubing, Heat Sealing Machine, Masking Tape, News Print , Pattern Board, Toilet Rolls, Strapping Machines (Hand & Semi Auto), Tag Pins, Double Sided Tapes, Cap Paper, Hand Tools, Bubble Wrap, Cotton Twine, Tidy Towels, Nelton, Pallet Wrap, Shrinkfilm, Self Adhesive labels, Jiffy Bags, Mail Lite Bags, Aerothene Bags, Plastic Hangers, Refuse Bags Welcome to the R.V. Packaging website. R.V. Packaging is a major supplier of all types of packaging products to the South African market. Below is a brief list of some of the products that we supply. Please send us email if something you require is not on our list and we will confirm whether we can supply you or not. Packaging Tapes & Dispensers, Gum Tape, (Plain & Printed) Plastic Strapping, Steel Strapping, Brown Paper, Corrugated Boxes & SFK Rolls, Staples & Stapling Machines,Plastic Bags (Plain & Printed), Recycle Tubing, Heat Sealing Machine, Masking Tape, News Print , Pattern Board, Toilet Rolls, Strapping Machines (Hand & Semi Auto), Tag Pins, Double Sided Tapes, Cap Paper, Hand Tools, Bubble Wrap, Cotton Twine, Tidy Towels, Nelton, Pallet Wrap, Shrinkfilm, Self Adhesive labels, Jiffy Bags, Mail Lite Bags, Aerothene Bags, Plastic Hangers, Refuse Bags packaging tapes, packaging dispensers, gum tape, plain, printed, plastic strapping, steel strapping, brown paper, corrugated boxes, sfk rolls, staples, stapling machines, plastic bags, recycle tubing, heat sealing machine, masking tape, news print, pattern board, toilet rolls, strapping machines, tag pins, double sided tapes, cap paper, hand tools, bubble wrap, cotton twine, tidy towels, nelton, pallet wrap, shrinkfilm, self adhesive labels, jiffy bags, mail lite bags, aerothene bags, plastic hangers, refuse bags

JS API Reference

For initial declarative chart setup. View asJSON, or aslegacy dump.json.

For modifying the chart at runtime. See theclass reference.

These pages outline the chart configuration options, and the methods and properties of Highcharts objects.

Feel free to search thisAPIthrough the search bar or the navigation tree in the sidebar.

Copyright © 2017, Highsoft AS. All rights reserved.

Highcharts v6.1.0 – Generated from branchHEAD(commitd00ad76), on Fri May 25 2018 09:50:40 GMT+0200 (W. Europe Daylight Time)

Coupon Code

Our Terms of Use and Privacy Policy are changing. Please review them. If you use our sites or applications on or after February 20th, 2018, you are agreeing to the newTerms of UseandPrivacy Policy.

Nordstrom,Macys,JCPenney,Kohls,Car Rentals,Walmart,Amazon

Favorited! Sign up to save all your favorites?

Check out our 6 Namebubbles discount codes including 5 sales, and 1 free shipping promotional code.

Sign Up for Namebubbles Email Newsletter and Receive Exclusive News & Offers

Would you recommend this store to a friend?

Sorry, we could not count your vote. Try again?

Check Out Namebubbles Products and Offers Today!

Namebubbles Gift Certificate starting at $25

Sign Up for Namebubbles Email Newsletter and Receive Exclusive News & Offers

Check Out Most Popular Products Section for Great Deals!

Check Out Personalized Phone Cases Today!

These have expired, but they may still work.

Name Bubbles is a provider of personalized name labels for your clothing and other personal items. Customers can receive savings by purchasing value packs that cost less than purchasing individual products. You can also take advantage of exclusive offers only available after you join the electronic mailing list. You can win free products by following them on social media sites.

Never miss another great coupon. Save more than before with savings alerts and new offers delivered right to your inbox.

Save effortlessly with paperless coupons! Link your store loyalty cards, add coupons, then shop and save.

Shop online with coupon codes from top retailers. Get Sears coupons, Best Buy coupons, and enjoy great savings with a Nordstrom promo code.

Find out more about how Coupons.com helps brands and retailers engage consumers with our portfolio of digital, social & mobile solutions.

Pacific Packaging

Strapping, Securing & Edge Protection

Protective, Bubble, Foam & Void Fill

Chip, Paperboard & Industrial Paper

Labels, Identification & Printed Tape

Industry leading packaging design, product and automation solutions

Lean, transparently integrated business processes to increase efficiency and lower costs

Scalable packaging systems optimizing your business efficiency and competitiveness

Founded in 1952, Pacific Packaging Products Inc. provides expert business solutions to increase our customers competitive edge and profitability. Whether it is in packaging design, packaging manufacturing and converting, packaging equipment and automation, or the utilization of Pacifics unparalleled USA coast-to-coast, Canadian, Mexican and Caribbean infrastructure to deliver lean, supply chain solutions, Pacific is the optimal partner for your demanding business. Pacific has the leverage and reach of a large multinational corporation, with the flexibility and innovation of a family owned, independent company.

how to find us

For driving directions to The Bubblecar Museum, click on the red pin on the map above and enter your current location, then click the directions button.

You will then be transfered to the Google map website where you can plan your route.

This site uses cookies:Find out more.Okay, thanks

solutions

Your browser is outdated and insecure!Please update your browser and benefit from modern features, faster load speed and increased security.

Disposable & Reusable Medical Equipment

Electrical Safety Tags, Tapes & Labels

Fire Equipment Cabinets, Stands & Trolleys

Work Trousers, Overalls & Underwear

Chemical Handling Guides & Booklets

Commercial Planters & Tree Protectors

Visitor Name Badges & Visitor Books

Despatch Envelopes & Packing Labels

Create and personalise your own products in just a few clicks

Environmentally friendly and always at your fingertips

© Copyright 2018 – SETON – a division of Brady Corporation Ltd.

We usecookieson this site to enhance your user experienceClose