Food and Wine

Food and Wine combine to delight your senses

Surrounded by the lush 30 year old Cabernet grapevines, herb garden and flower-filled baskets, dining at our Creekside Grille is an event in itself. Featuring a seasonal menu and locally-sources ingredients, our fresh, wine-inspired casual fare is perfect for almost any occasion.

Casual yet tasteful items fill the menu with delicious appetizers, gorgeous salads, scrumptious sandwiches, and of course Creekside seasonal inspired specials. As you might expect, the wine menu includes a variety of Wilson Creek wines, including our famous Almond Sparkling Wine.

TheCreekside Grilleis open Monday – Friday 11am – 4pm, Saturday 11am -5pm, Sunday 10am – 3pm. Rain or shine, the Grille is always open for dining whether its outside nestled near the grapevines in the covered patio or in our gorgeous Barrel Room.Call the Restaurant at

Sundays at the Grille will be strictly brunch with our Bubble Brunch Buffet!

Enjoy all your breakfast favorites, omelet stations, waffle stations, seafood stations, carving stations and dessert stations.

Buffet Prices:$43.95 per person $37.76 Wine Club

Buffet and Unlimited Sparkling Wine:$53.95 per person $46.76 Wine Club

Children 3 – 12:$16.95 $15.26 Wine Club

Have a comment or suggestion?Took a great picture while dining at the winery with your friends or family?

How about suggesting your favorite dish to be served at the Creekside Grille?

RESERVATIONS ACCEPTED FOR PARTIES 10 AND UNDER. PARTIES 11 TO 25 PLEASE LEAVE A MESSAGE AND WE WILL RETURN YOUR CALL.

All reservations must be made 24 hours before, but we recommend to make them 2 Weeks in Advance

Chili Cheese Dog Bubble-Up Bake

Bake-Off® Contest Breakfast Recipes

Bake-Off® Contest Appetizer Recipes

Christmas Breakfast + Brunch Recipes

4th of July Appetizers + Drinks Recipes

February: Classic Comfort Food With a Twist

January: Choose Your Own Dinner Adventure

December: Christmas is Made at Home

November: Thanksgiving Made at Home

Help Create Our New Christmas Cookie

Bring the family to the table with this hearty crowd-size take on the classic stadium favorite.

all-beef hot dogs, cut into bite-size pieces

cups shredded Cheddar cheese (8 oz)

cans (12 oz each) Pillsbury Flaky Layers refrigerated Buttermilk biscuits (10 biscuits each)

Heat oven to 375F. Lightly spray 13×9-inch (3-quart) baking dish with cooking spray; set aside.

Mix 1 can (28 oz) chili with beans and 8 all-beef hot dogs, cut into bite-size pieces, in baking dish. Top with 2 cups shredded Cheddar cheese (8 oz).

Open 2 cans (12 oz each) Pillsbury Grands! Jr. Golden Layers refrigerated biscuits; separate into biscuits, and cut each into 4 pieces. Place in large bowl; toss with 2 tablespoons melted butter, 1 teaspoon garlic powder and 1 teaspoon parsley flakes. Scatter biscuits on top of casserole.

Bake 20 to 22 minutes or until biscuits are light golden brown and cooked through. Let stand 5 minutes before serving.

Serve this comforting casserole with a side of freshly steamed green beans.

Boost the dish by adding 1 diced green bell pepper to the chili before baking.

No nutrition information available for this recipe

Provident Label Group

Please assign a menu to the primary menu location underMenus.

© DynamicFrameworks- Elite ThemeForest Author.

Sign Up For News And Exclusive Content

FEAR IS A LIAR OFFICIAL MUSIC VIDEO

CONTROL OFFICIAL MUSIC VIDEO

VERTICAL WORSHIP SET TO RELEASE NEW ALBUM, BRIGHT FAITH BOLD FUTURE, APRIL 6TH

THIRD DAY ANNOUNCES 2018 FAREWELL TOUR

WHATS GOING ON IN THE BUSY WORLD OF TAUREN WELLS?

Provident Music Group, a division of Sony Music, whose labels include Essential Records, Reunion Records, Essential Worship and Beach Street Records, is home to an artist roster which includesCasting Crowns(The Very Next Thing),Third Day(Revival),Tenth Avenue North(Followers),RED(Gone),Brandon Heath(Faith Hope Love Repeat), andTauren Wells(Hills And Valleys) among others. PMG also consists of Provident Films ( War Room, Courageous, Fireproof), Provident Distribution, Essential Music Publishing and Essential Artist Services.

Do you have a passion for music? Are you looking to enter the music industry?

If yes, then a career at Provident Label Group might be right for you!

Clicking on this link will launch a new window.

Please use the form below to contact us regarding interview requests or to obtain press materials for any Provident Artists.

Is the Tech Bubble Popping? Pingo Offers an Answer

Morning Editorial Report Newsletter

Trump-Putin Talks Are Set to Ease Russias Isolation

Russian Agency at Center of Hacking Indictment Long Operated in Shadows

New EPA Head Vows to Be Stabilizing Force After Pruitt Turmoil

Fill er Up, or Plug It In? Oil, Utilities Fight to Fuel Vehicles of the Future

Boeing, Airbus Strain to Deliver the New Jets They Have Promised

Theresa May Says Trump Advised Her to Sue the EU

How Carriers Get Permission to Share Your Whereabouts

Phones Killed Handwriting. Lets Bring It Back.

Cyberthieves Are Gravitating to Cryptocurrency Exchanges

Slate of U.S. Attorneys Aids Sessions Law-and-Order Push

Sizing Up the Bond Markets Signals

U.S. Stocks Enjoy Haven Status as Trade Spat Dings Other Markets

Is the Tech Bubble Popping? Ping Pong Offers an Answer

Sales of tables rise and fall with the startups that love them

SAN FRANCISCOTwitters gloomy quarterly report last week unsettled investors. They might have anticipated trouble more than a year ago had they noticed one key indicator.

Until late 2014, Twitter was regularly ordering ping-pong tables from Billiard Wholesale, a store in San Jose, Calif. Then, suddenly, it wasnt.

Tour de Frances Great Equalizer: The Cobbles

Mueller Probe Indicts 12 Russians for 2016 Election Hacking

The Future of U.S. Sports Betting: In-Play Wagers as You Watch

What Do Trump and Putin Want at the Helsinki Summit?

Gowdy, Strzok Spar Over Controversial Texts

Homeland Security Chief: Foreign Election-Meddling Has Consequences

McDonalds Pulls Salads From 3,000 Restaurants Amid Illnesses

The Sexting Scandal That Toppled One of Americas Most Powerful Lawyers

Angelique Kerber Wins Wimbledon as Unforced Errors Undermine Serena Williams

U.S. and Allies Consider Possible Oil-Reserve Release

Tour de Frances Great Equalizer: The Cobbles

Mueller Probe Indicts 12 Russians for 2016 Election Hacking

The Future of U.S. Sports Betting: In-Play Wagers as You Watch

What Do Trump and Putin Want at the Helsinki Summit?

Gowdy, Strzok Spar Over Controversial Texts

Homeland Security Chief: Foreign Election-Meddling Has Consequences

McDonalds Pulls Salads From 3,000 Restaurants Amid Illnesses

The Sexting Scandal That Toppled One of Americas Most Powerful Lawyers

Angelique Kerber Wins Wimbledon as Unforced Errors Undermine Serena Williams

U.S. and Allies Consider Possible Oil-Reserve Release

Background

FAQs regarding Safe Practices for Medical Injections

A Patient Safety Threat Syringe Reuse

Preventing Unsafe Injection Practices

CDC Clinical Reminder: Spinal Injection Procedures

U.S. Outbreaks Associated with Drug Diversion by Healthcare Providers, 1983-2013

Infection Prevention during Blood Glucose Monitoring and Insulin Administration

FAQs regarding Assisted Blood Glucose Monitoring and Insulin Administration

CDC Clinical Reminder: Use of Fingerstick Devices

Infection Control Assessment of Ambulatory Surgical Centers

Insurance Stakeholders Meeting December 2011

Ambulatory Surgical Centers October 2010

Sticking with Safety May 2010

Injection Safety Stakeholder Meeting December 2009

Developing Documents for a Patient Notification

Planning Media and Communication Strategies

Planning the Release of Media and Patient Notification Letters

Conducting a Successful Press Conference or Media Opportunity

Establishing Communication Resources

Best Practices in Conduting Patient Notifications

To receive email updates about this page, enter your email address:

Injection safety, or safe injection practices, is a set of measures taken to perform injections in an optimally safe manner for patients, healthcare personnel, and others.

The Standard Precautions section of the2007 Guideline for Isolation Precautions [PDF 3.80]provides evidence-based recommendations for safe injection practices and reflects the minimum standards that healthcare personnel should follow to prevent transmission of infections in healthcare settings.

Despite these recommendations, outbreaks and patient notifications resulting from healthcare personnel failing to adhere to Standard Precautions and basic infection control practices continue to be reported.Unsafe injection practicesthat have resulted in disease transmission have most commonly included:

Using the same syringe to administer medication to more than one patient, even if the needle was changed or the injection was administered through an intervening length of intravenous (IV) tubing [12];

Accessing a medication vial or bag with a syringe that has already been used to administer medication to a patient, then reusing contents from that vial or bag for another patient [36];

Using medications packaged as single-dose or single-use for more than one patient [79];

Failing to use aseptic technique when preparing and administering injections [1012].

For these reasons, CDC reminds healthcare personnel of the following practices that are critical for patient safety:

administer medications from the same syringe to more than one patient, even if the needle is changed or you are injecting through an intervening length of IV tubing.

enter a medication vial, bag, or bottle with a used syringe or needle.

use medications packaged as single-dose or single-use for more than one patient. This includes ampoules, bags, and bottles of intravenous solutions.

use aseptic technique when preparing and administering injections.

The following FAQs summarize inquiries received by CDC from healthcare personnel regarding safe use of needles, syringes, and injectable medications in patient care settings. Wherever possible we have attempted to provide examples of outbreaks or patient notification incidents that support the guidance offered in these FAQs. An extensive reference list is included at the end of this document.

These FAQs are not intended as a comprehensive resource for all safe injection practices and additional considerations may be necessary for certain clinical scenarios or settings. Healthcare personnel are encouraged to consult the Standard Precautions section of the2007 Guideline for Isolation Precautions [PDF 3.80]to ensure that their practices adhere to the basic principles of infection control and aseptic technique. Additional information applicable to specific clinical settings or procedures may be available from professional organizations.

While the use of aseptic technique when preparing and administering injectable medications is applicable to all healthcare settings, including pharmacy areas, these FAQs are not intended to reflect the standards and recommended practices for handling medication vials and related products in pharmacy settingsthese should be determined in accordance with the state boards of pharmacy, the United States Pharmacopeia (USP), the Drug Enforcement Agency (DEA), and the Food and Drug Administration (FDA).

To receive email updates about this page, enter your email address:

National Center for Emerging and Zoonotic Infectious Diseases (NCEZID)

DrJart+ USA

Shake & Shot Rubber Brightening Mask

Cicapair Tiger Grass Color Correcting Treatment

Dermaclear Micro Makeup Remover Pads

Every Sun Day UV Illuminating Sunscreen

Dermask Vital Hydra Solution Deep Hydration Sheet Mask

Dermask Soothing Hydra Solution Deep Hydration Sheet Mask

Dermask Clearing Solution Ultra-Fine Microfiber Sheet Mask

Dermask Brightening Solution Ultra-Fine Microfiber Sheet Mask

Dermask Firming Solution Body Heat Thermosensitive Cellulose Gel Mask

Dermask Wrinkless Solution Body Heat Thermosensitive Cellulose Gel Mask

Ceramidin Skin-Friendly Nanoskin Sheet Mask

All That Contours Hydrogel Expansion Stretch Mask

Water Replenishment Cotton Sheet Mask

All Dr. Jart products are thoroughly tested and approved by the consulting group of dermatologists to be safe for all skin types even hypersensitive skin and pregnant women.

South Sea Company

From Wikipedia, the free encyclopedia

South Sea Bubble redirects here. For the Noel Coward play, seeSouth Sea Bubble (play).

1754 engraving of Old South Sea House, the headquarters of the South Sea Company, burned down in 1826,

on the corner ofBishopsgate StreetandThreadneedle Streetin theCity of London

TheDividendHall of South Sea House, 1810

Azure, a globe whereon are represented theStraits of MagellanandCape Hornallproperand insinisterchief point two herrings haurient in saltire argent crowned or, in acantontheunited arms of Great Britain

Heraldic grouping above main entrance to the surviving South Sea House, Threadneedle Street, rebuilt after the fire of 1826

An early trade label of the South Sea Company, for export of finest Englishsergecloth. The letters circumscribing the seal below should read SS&FC, for South Sea and Fishery Company

1733 share certificate of the South Sea Company showing the Companys coat of arms and the Latin motto

(FromCadizto Dawn,JuvenalSatires, 10)

Hogarthianimage of the 1720 South Sea Bubble from the mid-19th century, byEdward Matthew WardTate Gallery

TheSouth Sea Company(officiallyThe Governor and Company of the merchants of Great Britain, trading to the South Seas and other parts of America, and for the encouragement of fishing)[3]was a Britishjoint-stock companyfounded in 1711, created as apublic-private partnershipto consolidate and reduce the cost of national debt. The company was also granted a monopoly to trade with South America and nearby islands, hence its name (the modern use of the term South Seas to refer to the entire South Pacific was unknown in England at the time). When the company was created, Britain was involved in theWar of the Spanish Successionand Spain controlled South America. There was no realistic prospect that trade would take place and the company never realised any significant profit from its monopoly. Company stock rose greatly in value as it expanded its operations dealing in government debt, peaking in 1720 before collapsing to little above its originalflotationprice; theeconomic bubblebecame known as theSouth Sea Bubble.

TheBubble Act1720 (6 Geo I, c 18), which forbade the creation of joint-stock companies withoutroyal charter, was promoted by the South Sea company itself before its collapse.

In Great Britain, a considerable number of people were ruined by the share collapse, and the national economy greatly reduced as a result. The founders of the scheme engaged ininsider trading, using their advance knowledge of when national debt was to be consolidated to make large profits from purchasing debt in advance. Huge bribes were given to politicians to support theActs of Parliamentnecessary for the scheme.[4]Company money was used to deal in its own shares, and selected individuals purchasing shares were given loans backed by those same shares to spend on purchasing more shares. The expectation of profits from trade with South America was used to encourage the public to purchase shares, but the bubble prices reached far beyond the profits of the slave trade.[5]

A parliamentary enquiry was held after the crash to discover its causes. A number of politicians were disgraced, and people found to have profited unlawfully from the company had assets confiscated proportionate to their gains (most had already been rich men and remained comfortably rich). The company was restructured and continued to operate for more than a century after the Bubble. The headquarters were inThreadneedle Streetat the centre of the financial district in London. At the time of these events theBank of Englandalso was a private company dealing in national debt, and the crash of its rival consolidated its position as banker to the British government.[6]

In August 1710Robert Harleywas appointedChancellor of the Exchequerin a government of commission. The government at this time had become reliant on theBank of England. This was a privately owned company, chartered 16 years previously, which had obtained a monopoly as the lender to Westminster, in return for arranging and managing loans to the government. The government had become dissatisfied with the service it was receiving and Harley was actively seeking new ways to improve the national finances.

A new Parliament met in November 1710 with a resolve to attend to national finances, which were suffering significantly fromtwo simultaneous wars: thewar with France, which ended in 1713, and theGreat Northern War, which was not to end until 1721. Harley came prepared, with detailed accounts of the situation of the national debt, which was customarily a piecemeal affair, with different government departments arranging their own loans as the need arose. He released the information steadily, continually adding new reports of debts incurred and scandalous expenditure, until in January 1711 the House of Commons agreed to appoint a committee to investigate the entire debt. The committee included Harley himself; the twoAuditors of the Imprests, whose task was to investigate government spending; Harleys brotherEdward; and Paul Foley, his brother-in-law. Also included were theSecretary of the TreasuryWilliam Lowndes, who had had significant responsibility for reminting the entire debased British coinage in 1696; andJohn Aislabiewho represented theOctober Club, a group of around 200 MPs who had agreed to vote together.[7]

Harleys first concern was to find 300,000 for the next quarters pay for the British army operating in Europe underMarlborough. This was provided by a private consortium ofEdward Gibbon,[8]George CaswallandHoares Bank. The Bank of England had been operating a state lottery on behalf of the government, but this had not been particularly successful in 1710, and another had already begun in 1711. This too was performing poorly, so Harley granted authority to sell tickets toJohn Blunt, a director of theHollow Sword Blade Company, which despite its name was an unofficial bank. With sales commencing on 3 March 1711, tickets had completely sold out by the 7th. This was the first truly successful English state lottery.[9]

The success was shortly followed by another, larger, lottery, The Two Million Adventure or The Classis, with tickets costing 100, a top prize of 20,000 and every ticket winning a prize of at least 10. Although prizes were advertised by their total amount, they were paid in the form of a fixed annuity over a period of years, so that the government effectively held the prize money as a loan until it was paid out to the winners. Marketing was handled by members of the Sword Blade syndicate, Gibbon selling 200,000 of tickets and earning 4,500 commission, and Blunt selling 993,000. Charles Blunt (a relative) was made Paymaster of the lottery with expenses of 5,000.

The national debt investigation had concluded that a total of 9,000,000 was owed, without any allocated income to pay it off. Edward Harley and John Blunt together had devised a scheme to consolidate this debt in much the same way that the Bank of England had consolidated previous debts, although the Bank still held the monopoly on operating as a bank. All holders of the debt would be required to surrender it to a new company, the South Sea Company, which in return would issue shares to the same amount. The government would pay the company 568,279 10s 0d (6% interest plus expenses) annually, which would be distributed as a dividend to shareholders. The company was also given a monopoly to trade with South America, a potentially lucrative enterprise, but one controlled by Spain, with whom Britain was at war.[10]

At that time, when continental America was being explored and colonized, Europeans applied the term South Seas only to South America and surrounding waters. The concession both held out the potential for future profits and encouraged a desire for an end to the war, necessary if any profits were to be made. The original suggestion for the South Sea scheme came fromWilliam Paterson, one of the founders of the Bank of England and the financially disastrousDarien Scheme.[10]

Harley was rewarded for the scheme by being created Earl of Oxford on 23 May 1711, and was promoted toLord High Treasurer. With a more secure position, he began secret peace negotiations with France. Commercially, since the lotteries were discredited, some of the debt intended to be consolidated under the scheme was available in the open market before the scheme was announced, at a discounted rate of 55 per 100 nominal value. This allowed anyone with advance knowledge to buy debt cheap and sell at an immediate profit, and made it possible for Harley to bring further financial supporters into the scheme, such as James Bateman andTheodore Janssen.[11]

Unless the Spaniards are to be divested of common sense, infatuate, and given up, abandoning their own commerce, throwing away the only valuable stake they have left in the world, and in short, bent on their own ruin, we cannot suggest that they will ever, on any consideration, or for any equivalent, part with so valuable, indeed so inestimable a jewel, as the exclusive trade to their own plantations.

The originators of the scheme knew that there was no money to invest in a trading venture, and no realistic expectation there would ever be a trade to exploit, but the potential for great wealth was widely publicised at every opportunity, so as to encourage interest in the scheme. The objective for the founders was to create a company which they could use to become wealthy, and which offered future scope for further government deals.[13]

The Charter for the company was drawn up by Blunt, based on that of the Bank of England. Blunt was paid 3,846 for his services in setting up the company. Directors would be elected every three years while shareholders would meet twice a year. The company employed a Cashier, Secretary and Accountant. The Governor was intended to be an honorary position, and the position was later customarily held by the ruling monarch. The charter allowed the full court of directors to nominate a smaller committee to act on any matter on its behalf. Directors of the Bank of England and of theEast India Companywere disbarred from being a director of the South Sea Company. Any ship of more than 500 tons owned by the company was to have a Church of England clergyman on board.

The exchange of government debt for stock was to occur in five separate lots. The first two of these, totaling 2.75 million from about 200 large investors, had already been arranged before the companys charter was issued on 10 September 1711. The government itself exchanged 0.75 million of its own debt held by different departments (at this time, individual office holders were responsible for money in their charge, and were at liberty to invest it to their own advantage before it was required). Harley exchanged 8,000 of debt and was appointed Governor of the new company. Blunt, Caswall and Sawbridge together provided 65,000, Janssen 25,000 of his own plus 250,000 from a foreign consortium, Decker 49,000, Sir Ambrose Crawley 36,791. The company had a Sub-Governor, Bateman; a Deputy Governor, Ongley; and 30 ordinary directors. In total, nine of the directors were politicians, five were members of the Sword Blade consortium, and seven more were financial magnates who had been attracted to the scheme.[14]

The company created a coat of arms with the mottoA Gadibus usque ad Auroram(from Cadiz to the dawn) and rented a large house in the City as its headquarters. Seven sub-committees were created to handle its everyday business, the most important being the Committee for the affairs of the company. The Sword Blade company was retained as their banker and on the strength of its new government connections issued notes in its own right, notwithstanding the Bank of England monopoly. The task of the Company Secretary was to oversee trading activities; the Accountant, Grigsby, was responsible for registering and issuing stock; and the Cashier, Robert Knight, acted as Blunts personal assistant at a salary of 200 per year.[15]

TheTreaty of Utrechtof 1713 granted Britain anAsientolasting 30 years to supply the Spanish colonies with 4,800 slaves per year. Britain was permitted to open offices inBuenos AiresCaracasCartagenaHavanaPanamaPortobelloandVera Cruzto arrange theAtlantic slave trade. One ship of no more than 500 tons could be sent to one of these places each year (theNavo de Permiso) with general trade goods. One quarter of the profits were to be reserved for the King of Spain. There was provision for two extra sailings at the start of the contract. The Asiento was granted in the name ofQueen Anneand then contracted to the company.[16]

By July the company had arranged contracts with theRoyal African Companyto supply the necessary African slaves to Jamaica. Ten pounds was paid for a slave aged over 16, 8 for one under 16 but over 10. Two-thirds were to be male, and 90% adult. The company trans-shipped 1,230 slaves from Jamaica to America in the first year, plus any that might have been added (against standing instructions) by the ships captains on their own behalf. On arrival of the first cargoes, the local authorities refused to accept the Asiento, which had still not been officially confirmed there by the Spanish authorities. The slaves were eventually sold at a loss in the West Indies.[17]

In 1714 the government announced that a quarter of profits would be reserved for the Queen and a further 7.5% for a financial advisor, Manasseh Gilligan. Some Company board members refused to accept the contract on these terms, and the government was obliged to reverse its decision.[18]

Despite these setbacks, the company continued, having raised 200,000 to finance the operations. In 1714 2,680 slaves were carried, and for 171617, 13,000 more, but the trade continued to be unprofitable. An import duty of 33pieces of eightwas charged on each slave (although for this purpose some slaves might be counted only as a fraction of a slave, depending on quality). One of the extra trade ships was sent to Cartagena in 1714 carrying woollen goods, despite warnings that there was no market for them there, and they remained unsold for two years.[19]

The company was heavily dependent on the goodwill of government; when the government changed, so too did the company board. In 1714 one of the directors who had been sponsored by Harley, Arthur Moore, had attempted to send 60 tons of private goods on board the company ship. He was dismissed as a director, but the result was the beginning of Harleys fall from favour with the company. On 27 July 1714, Harley was replaced as Lord High Treasurer as a result of a disagreement that had broken out within the Tory faction in parliament. Queen Anne died on 1 August 1714; and at the election of directors in 1715 the Prince of Wales (the future KingGeorge II) was elected as Governor of the Company. The new KingGeorge Iand the Prince of Wales both had significant holdings in the company, as did some prominent Whig politicians, includingJames Craggs the Elder, the Earl of Halifax and Sir Joseph Jekyll. James Craggs, as Postmaster General, was responsible for intercepting mail on behalf of the government to obtain political and financial information. All Tory politicians were removed from the board and replaced with businessmen. The Whigs Horatio Townshend, brother in law ofRobert Walpole, and theDuke of Argyllwere elected directors.

The new government led to a revival of the companys share value, which had fallen below its issue price. The previous government had failed to make the interest payments to the company for the last two years, owing more than 1 million. The new administration insisted the debt be written off, but allowed the company to issue new shares to stockholders to the value of the missed payments. At around 10 million, this now represented half the share capital issued in the entire country. In 1714 the company had 2,000 to 3,000 shareholders, more than either of its rivals.[20]

By the time of the next directors elections in 1718 politics had changed again, with a schism within the Whigs between Walpoles faction supporting the Prince of Wales andJames Stanhopes supporting the King. Argyll and Townshend were dismissed as directors, as were surviving Tories Sir Richard Hoare and George Pitt, and King George I became governor. Four MPs remained directors, as did six people holding government financial offices. The Sword Blade Company remained bankers to the South Sea, and indeed had flourished despite the companys dubious legal position. Blunt and Sawbridge remained South Sea directors, and they had been joined by Gibbon and Child. Caswall had retired as a South Sea director to concentrate on the Sword Blade business. In November 1718 Sub-Governor Bateman and Deputy Governor Shepheard both died. Leaving aside the honorary position of Governor, this left the company suddenly without its two most senior and experienced directors. They were replaced by Sir John Fellowes as Sub-Governor and Charles Joye as Deputy.[21]

In 1718 war broke out with Spain once again, in theWar of the Quadruple Alliance. The companys assets in South America were seized, which the company claimed cost it 300,000. Any prospect of profit from trade, for which the company had purchased ships and had been planning its next ventures, disappeared.[22]

Events in France now came to influence the future of the company. A Scottish economist and financier,John Law, exiled after killing a man in a duel, had travelled around Europe before settling in France. There he founded a bank, which in December 1718 became the Banque Royale, national bank of France, while Law himself was granted sweeping powers to control the economy of France, which operated largely by royal decree. Laws remarkable success was known in financial circles throughout Europe, and now came to inspire Blunt and his associates to make greater efforts to grow their own concerns.[23]

In February 1719 Craggs explained to the House of Commons a new scheme for improving the national debt by converting the annuities issued after the 1710 lottery into South Sea stock. By Act of Parliament, the company was granted the right to issue 1,150 of new stock for every 100 per annum of annuity which was surrendered. The government would pay 5% per annum on the stock created, which would halve their annual bill. The conversion was voluntary, amounting to 2.5 million new stock if all converted. The company was to make an additional new loan to the government pro-rata up to 750,000, again at 5%.[24]

The South Sea company presented the offer to the public in July 1719. In March there was an abortive attempt to restore the Old Pretender,James Edward Stuart, to the throne of Britain, with a small landing of troops in Scotland. They were defeated at theBattle of Glen Shielon 10 June. The Sword Blade company spread a rumour that the Pretender had been captured, and the general euphoria encouraged the South Sea share price to rise from 100, where it had been in the spring, to 114. Annuitants were still paid out at the same money value of shares, the company keeping the profit from the rise in value before issuing. About two-thirds of the in-force annuities were exchanged.

Emblematical Print on the South Sea Scheme

(1721). In the bottom left corner are Protestant, Catholic, and Jewish figures gambling, while in the middle there is a huge machine, like a merry-go-round, which people are boarding. At the top is a goat, written below which is Whol Ride. The people are scattered around the picture with a sense of disorder, while the progress of the well-dressed people towards the ride in the middle represents the foolishness of the crowd in buying stock in the South Sea Company, which spent more time issuing stock than anything else.

The 1719 scheme was a distinct success from the governments perspective, and they sought to repeat it. Negotiations took place between Aislabie and Craggs for the government and Blunt, Cashier Knight and his assistant and Caswell. Janssen, the Sub Governor and Deputy Governor were also consulted but negotiations remained secret from most of the company. News from France was of fortunes being made investing in Laws bank, whose shares had risen sharply. Money was moving around Europe, and other flotations threatened to soak up available capital (two insurance schemes in December 1719 each sought to raise 3 million).[25]

Plans were made for a new scheme to take over most of the unconsolidated national debt of Britain (30,981,712) in exchange for company shares. Annuities were valued as a lump sum necessary to produce the annual income over the original term at an assumed interest of 5%, which favoured those with shorter terms still to run. The government agreed to pay the same amount to the company for all the fixed term repayable debt as it had been paying before, but after seven years the 5% interest rate would fall to 4% on both the new annuity debt and also that taken over previously. After the first year, the company was to give the government 3 million in four quarterly installments. New stock would be created at a face value equal to the debt, but the share price was still rising and sales of the remaining stock, i.e. the excess of the total market value of the stock over the amount of the debt, would be used to raise the government fee plus a profit for the company. The more the price rose in advance of conversion, the more the company would make. Before the scheme, payments were costing the government 1.5 million per year.[26]

In summary, the total government debt in 1719 was 50 million:

18.3m was held by three large corporations:

3.2m by theBritish East India Company

Privately held redeemable debt amounted to 16.5m

15m consisted of irredeemable annuities, long-fixed-term annuities of 7287 years, and short annuities of 22 years remaining to expiry.

The purpose of this conversion was similar to the old one: debt holders and annuitants might receive less return in total, but an illiquid investment was transformed into shares which could be readily traded. Shares backed by national debt were considered a safe investment and a convenient way to hold and move money: far easier and safer than metal coins. The only alternative safe asset, land, was much harder to sell and it was legally much more complex to transfer ownership.

The government received a cash payment and lower overall interest on the debt. Importantly, it also gained control over when the debt had to be repaid, which was not before seven years but then at its discretion. This avoided the risk that debt might become repayable at some future point just when the government needed to borrow more, and could be forced into paying higher interest rates. The payment to the government was to be used to buy in any debt not subscribed to the scheme, which although it helped the government also helped the company by removing possibly competing securities from the market, including large holdings by the Bank of England.[26]

Company stock was now trading at 123, so the issue amounted to an injection of 5 million of new money into a booming economy just as interest rates were falling.Gross Domestic Product(GDP) for Britain at this point was estimated as 64.4 million.[2]

On 21 January the plan was presented to the board of the South Sea Company, and on 22 Januarypresented it to Parliament. The House was stunned into silence, but on recovering proposed that the Bank of England should be invited to make a better offer. In response, the South Sea increased its cash payment to 3.5 million, while the Bank proposed to undertake the conversion with a payment of 5.5 million and a fixed conversion price of 170 per 100 face value Bank stock. On 1 February, the company negotiators led by Blunt raised their offer to 4 million plus a proportion of 3.5 million depending on how much of the debt was converted. They also agreed that the interest rate would reduce after four years instead of seven, and agreed to sell on behalf of the government 1 million of Exchequer bills (formerly handled by the Bank). The House accepted the South Sea offer. Bank stock fell sharply.[27]

Perhaps the first sign of difficulty came when the South Sea Company announced that its Christmas 1719 dividend would be deferred for 12 months. The company now embarked on a show of gratitude to its friends. Select individuals were sold a parcel of company stock at the current price. The transactions were recorded by Knight in the names of intermediaries, but no payments were received and no stock issued indeed the company had none to issue until the conversion of debt began. The individual received an option to sell his stock back to the company at any future date at whatever market price might then apply. Shares went to the Craggs:the Elderandthe YoungerLord GowerLord Lansdowne; and four other MPs.Lord Sunderlandwould gain 500 for every pound that stock rose; George Is mistress, their children and Countess Platen 120 per pound rise, Aislabie 200 per pound,Lord Stanhope600 per pound. Others invested money, including theTreasurer to the Navy, Hampden, who invested 25,000 of government money on his own behalf.[28]

The proposal was accepted in a slightly altered form in April 1720. Crucial in this conversion was the proportion of holders of irredeemable annuities who could be tempted to convert their securities at a high price for the new shares. (Holders of redeemable debt had effectively no other choice but to subscribe.) The South Sea Company could set the conversion price but could not diverge much from the market price of its shares. The company ultimately acquired 85% of the redeemables and 80% of the irredeemables.

Please helpimprove this sectionbyadding citations to reliable sources. Unsourced material may be challenged andremoved.

(Learn how and when to remove this template message)

The company then set to talking up its stock with the most extravagant rumours of the value of its potential trade in the New World; this was followed by a wave of speculating frenzy. The share price had risen from the time the scheme was proposed: from 128 in January 1720, to 175 in February, 330 in March and, following the schemes acceptance, 550 at the end of May.

What may have supported the companys high multiples (itsP/E ratio) was a fund of credit (known to the market) of 70 million available for commercial expansion which had been made available through substantial support, apparently, by Parliament and the King.

Shares in the company were sold to politicians at the current market price; however, rather than paying for the shares, these recipients simply held on to what shares they had been offered, with the option of selling them back to the company when and as they chose, receiving as profit the increase in market price. This method, while winning over the heads of government, the Kings mistress, et al., also had the advantage of binding their interests to the interests of the Company: in order to secure their own profits, they had to help drive up the stock. Meanwhile, by publicising the names of their elite stockholders, the Company managed to clothe itself in an aura of legitimacy, which attracted and kept other buyers.

The South Sea Company was by no means the only company seeking to raise money from investors in 1720. A large number of other joint-stock companies had been created making extravagant (sometimes fraudulent) claims about foreign or other ventures or bizarre schemes. Others represented potentially sound, although novel, schemes, such as for founding insurance companies. These were nicknamed Bubbles. Some of the companies had no legal basis, while others, such as the Hollow Sword Blade company acting as the South Seas banker, used existing chartered companies for purposes entirely different from their creation. The York Buildings Company was set up to provide water to London, but was purchased by Case Billingsley who used it to purchase confiscated Jacobite estates in Scotland, which then formed the assets of an insurance company.[29]

On 22 February 1720 John Hungerford raised the question of bubble companies in the House of Commons, and persuaded the House to set up a committee, which he chaired, to investigate. He identified a number of companies which between them sought to raise 40 million in capital. The committee investigated the companies, establishing a principle that companies should not be operating outside the objects specified in their charters. A potential embarrassment for the South Sea was avoided when the question of the Hollow Sword Blade Company arose. Difficulty was avoided by flooding the committee with MPs who were supporters of the South Sea, and voting down the proposal to investigate the Hollow Sword by 75 to 25. (At this time, committees of the House were either Open or secret. A secret committee was one with a fixed set of members who could vote on its proceedings. By contrast, any MP could join in with an open committee and vote on its proceedings.) Stanhope, who was a member of the committee, received 50,000 of the resaleable South Sea stock from Sawbridge, a director of the Hollow Sword, at about this time. Hungerford had previously been expelled from the Commons for accepting a bribe.[29]

Amongst the bubble companies investigated were two supported by Lords Onslow and Chetwynd respectively, for insuring shipping. These were criticised heavily, and the questionable dealings of the Attorney-General and Solicitor-General in trying to obtain

Shipping Suppl

When you shop with Shipping Supply you can count on everyday low prices. We buy in bulk so you dont have to. On top of those everyday low prices, we also spotlight an item every single day and mark it down. Check ourfacebookpage every day to see what it is!

The difference between us and the competition is how we treat our customerswe like to treat each and every customer with the same level of professionalism and courtesy when they come to us for packing materials and supplies, regardless of their size or budget. Need to stock up or replenish some shipping supplies? Take advantage of our daily salessubscribe to ourweekly newsletterto have them delivered to your inbox. Youll be able to loosely plan your purchases around the daily deals and weekly e-mail promotions in order to really save with us over time.

The e-mails will not only help you save on shipping costs, but will hopefully entertain you as well. Every product we carry offers a practical and fun benefit to your business. You can rely on us to help keep your assets safe and your customers safe. Would you like to make an impression on a new customer or do you have an important package to send?order some of ourWhite Corrugated Boxesand stand out from the competition. Order some air wrapped up in plastic, erI mean,Bubble Wrapto save on shipping costs and ship at actual weight.

Enjoy our customer satisfaction guarantee99% of orders ship within 24 hours of purchase and if you arent completely satisfied you can return it within 10 days of receipt for a cash refund or replacement. Feel free to spend some time with us here at m. If you should need anything, pick up the phone and give us a call at 1-877-501-Pack.

How to add labels in bubble chart in Excel?

Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.

Please enter the email address associated with your User account. Your username will be emailed to the email address on file.

Required field,LM5416e3590b59c:jform[elem_type]:value:textfield,defaultValue:text,predefined:name,readonly:true,button:Name,icon:icon-user,jform[elem_required]:checked:true,disabled:false,value:true,jform[elem_wide]:checked:false,jform[elem_class]:value:ial-name,jform[elem_name]:value:name,readonly:true,prefix:jform[,jform[elem_prefix]:value:jform,jform[elem_label]:value:Name:,jform[elem_placeholder]:value:,jform[elem_title]:value:Please enter your full name.,jform[elem_pattern]:value:.+,placeholder:.+,jform[elem_error]:value:Invalid field: %s,jform[elem_id]:value:ial-name,LM5416e3590b59e:jform[elem_type]:value:textfield,defaultValue:text,predefined:username,readonly:true,button:Username,icon:icon-user,jform[elem_required]:checked:true,disabled:true,value:true,jform[elem_wide]:checked:false,jform[elem_class]:value:ial-username,jform[elem_name]:value:username,readonly:true,prefix:jform[,jform[elem_prefix]:value:jform,jform[elem_label]:value:Username:,jform[elem_placeholder]:value:,jform[elem_title]:value:Please enter your username.,jform[elem_error]:value:Please enter a valid username. No spaces, at least 2 characters and must

\\ \ % ; ( ) &,jform[elem_pattern]:value:^[^\\\\\\(\\)]2,$,placeholder:^[^\\\\\\(\\)]2,$,jform[elem_ajax]:username,jform[elem_id]:value:ial-username,LM5720b6b972781:jform[elem_type]:value:password1,defaultValue:password,predefined:password1,readonly:true,button:Password,icon:icon-lock,jform[elem_required]:checked:true,disabled:true,value:true,jform[elem_wide]:checked:false,jform[elem_class]:value:ial-password1,jform[elem_name]:value:password1,readonly:true,jform[elem_prefix]:value:jform,jform[elem_label]:value:Password:,jform[elem_placeholder]:value:,jform[elem_title]:value:Please enter your password.,jform[elem_error]:value:Invalid field: %s,LM5416e3590b59f:jform[elem_type]:value:password2,defaultValue:password,predefined:password2,readonly:true,button:Password again,icon:icon-lock,jform[elem_required]:checked:true,disabled:true,value:true,jform[elem_wide]:checked:false,jform[elem_class]:value:ial-password2,jform[elem_name]:value:password2,readonly:true,prefix:jform[,jform[elem_prefix]:value:jform,jform[elem_label]:value:Confirm Password:,jform[elem_placeholder]:value:,jform[elem_title]:value:Please confirm your password.,jform[elem_error]:value:The passwords you entered do not match. Please enter your desired password in the password field and confirm your entry by entering it in the confirm password field.,jform[elem_id]:value:ial-password2,LM5416e3590b5a1:jform[elem_type]:value:textfield,defaultValue:text,predefined:email,readonly:true,button:Email,icon:icon-mail-2 icon-envelope,jform[elem_required]:checked:true,disabled:true,value:true,jform[elem_wide]:checked:false,jform[elem_class]:value:ial-email1,jform[elem_name]:value:email1,readonly:true,prefix:jform[,jform[elem_prefix]:value:jform,jform[elem_label]:value:Email Address:,jform[elem_placeholder]:value:,jform[elem_title]:value:Please enter your email address.,jform[elem_error]:value:Invalid email address,jform[elem_pattern]:value:^([\\w0-9\\.\\-])+\\@(([a-zA-Z0-9\\-])+\\.)+[a-zA-Z]2,4$,placeholder:^([\\w0-9\\.\\-])+\\@(([a-zA-Z0-9\\-])+\\.)+[a-zA-Z]2,4$,jform[elem_ajax]:email,jform[elem_id]:value:ial-email1,LM5416e3590b5a2:jform[elem_type]:value:textfield,defaultValue:text,predefined:email2,readonly:true,button:Email again,icon:icon-mail-2 icon-envelope,jform[elem_required]:checked:true,disabled:true,value:true,jform[elem_wide]:checked:false,jform[elem_class]:value:ial-email2,jform[elem_name]:value:email2,readonly:true,prefix:jform[,jform[elem_prefix]:value:jform,jform[elem_label]:value:Confirm email Address:,jform[elem_placeholder]:value:,jform[elem_title]:value:Please confirm your email address.,jform[elem_error]:value:The email addresses you entered do not match. Please enter your email address in the email address field and confirm your entry by entering it in the confirm email field.,jform[elem_id]:value:ial-email2,LM5987c19ab0f78:jform[elem_type]:value:captcha,predefined:captcha,readonly:true,button:Captcha image,icon:icon-picture,jform[elem_class]:value:,jform[elem_wide]:checked:true,value:true,LM5416e3590b5a4:jform[elem_type]:value:button,predefined:submit,readonly:true,button:Submit,icon:icon-arrow-right,jform[elem_wide]:checked:false,jform[elem_class]:value:,jform[elem_label]:value:Register,jform[elem_subtitle]:value:],ialProps=layout:jform[layout_columns]:2,jform[layout_margin]:10px,jform[layout_width]:190px;

Tips & Tricks in Chinese (Simplified)

Tips & Tricks in Chinese (Traditional)

768)$(.megamenucss503 .jux_tabs_db).addClass(jux_tabs_item);$(.megamenucss503 .js-megamenu).removeClass(dropdown-menucssjs-meganav);$(.jux-custom-css).removeClass(accordion-btn-wrap)else$(.megamenucss503 .jux_tabs_db).removeClass(jux_tabs_item)));

How to add labels in bubble chart in Excel?

When you quickly create a bubble chart in Excel, the chart will have one series and the bubbles in your bubble chart may be filled with the same color as shown as below screenshot, which makes you difficult to distinguish them in Excel. But if you add labels of name for the bubbles, you can easy to get it.

Office Tab:Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.Try now

Kutools for Excel:200 new features for Excel, make Excel much easy and powerful, increase productivity immediately.Try now

To add labels of name to bubbles, you need to show the labels first.

1. Right click at any bubble and selectAdd Data Labelsfrom context menu.

2. Then click at one label, then click at it again to select it only. See screenshot:

3. Then type=into theFormula bar, and then select the cell of the relative name you need, and press theEnterkey. See screenshot:

4. PressEnter. You can see the label has change to show the name.

Note: You can also type text as you need directly into the text box after you selecting the label.

5. Repeat to change the others labels. And the bubble chart will be shown as below:

Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Amazing! Increase your productivity in 5 minutes. Dont need any special skills, save two hours every day!

200 New Features for Excel, Make Excel Much Easy and Powerful:

Merge Cell/Rows/Columns without Losing Data.

Combine and Consolidate Multiple Sheets and Workbooks.

Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.

Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,

More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools…

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

.jcm-post-content

.jcm-flex-content,jlexcomment ._media_box,jlexcomment ._media_box button,jlexcomment ._off .forOff,jlexcomment ._on .forOn,jlexcomment ._postAsGuest input,jlexcomment ._tbox .react-box,jlexcomment ._tbox .reaction-btn,jlexcomment ._tbox .reaction-btn.active,jlexcomment .clearfix,jlexcomment unt-0 .jcm-count,jlexcomment .forGuest,jlexcomment .forGuest h6,jlexcomment .forOff,jlexcomment .forOn,jlexcomment .hovercard,jlexcomment .hovercard + .jcm-form,jlexcomment .hovercard + .jcm-post-content,jlexcomment .hovercard img,jlexcomment .jcm-author a,jlexcomment .jcm-bad-word,jlexcomment .jcm-block,jlexcomment .jcm-block + .jcm-block,jlexcomment .jcm-block.jcm-collapse

.jcm-post-content

.jcm-flex-content .jcm-task-expand,jlexcomment .jcm-block.jcm-collapse

.jcm-post-content

.jcm-list-reply,jlexcomment .jcm-block.jcm-expand

.jcm-post-content

.jcm-flex-content .jcm-task-collapse,jlexcomment .jcm-btn-image,jlexcomment .jcm-btn-open,jlexcomment .jcm-btn-open.active,jlexcomment .jcm-bullet,jlexcomment .jcm-button,jlexcomment .jcm-button-hl,jlexcomment .jcm-center,jlexcomment .jcm-childs .hovercard,jlexcomment .jcm-childs .jcm-post-content,jlexcomment .jcm-comment-edit .hovercard,jlexcomment .jcm-comment-edit .jcm-btn-cancel,jlexcomment .jcm-comment-edit .jcm-form,jlexcomment .jcm-comment-edit .jcm-map-status,jlexcomment .jcm-connect,jlexcomment .jcm-count-nof span,jlexcomment .jcm-date,jlexcomment .jcm-dropdown,jlexcomment .jcm-dropdown-menu

li,jlexcomment .jcm-dropdown-menu

li

._dx,jlexcomment .jcm-dropdown-menu

li

._dx [class^=\jcm-icon-\],jlexcomment .jcm-dropdown-menu

li

._dx.active,jlexcomment .jcm-dropdown.active ul.jcm-dropdown-menu,jlexcomment .jcm-dropdown.onRight ul.jcm-dropdown-menu,jlexcomment .jcm-empty-cm,jlexcomment .jcm-extra-admin,jlexcomment .jcm-featured

.jcm-post-content

.jcm-flex-content,jlexcomment .jcm-files-attached,jlexcomment .jcm-files-attached ._caption,jlexcomment .jcm-files-attached ._on + p._desc,jlexcomment .jcm-files-attached a._detail,jlexcomment .jcm-files-attached a._title,jlexcomment .jcm-files-attached li,jlexcomment .jcm-files-attached p._desc,jlexcomment .jcm-flex-content,jlexcomment .jcm-flex-content .jcm-post-header

.jcm-q-menu,jlexcomment .jcm-form,jlexcomment .jcm-form-cp,jlexcomment .jcm-form-cp.active ._controller,jlexcomment .jcm-form-cp.active .forGuest,jlexcomment .jcm-form-cp.active .jcm-input-cm,jlexcomment .jcm-form-cp.active .jcm-symbol-limit,jlexcomment .jcm-form-cp.active .jcm-textarea,jlexcomment .jcm-form.error,jlexcomment .jcm-h6,jlexcomment .jcm-inline-top

*,jlexcomment .jcm-input-cm,jlexcomment .jcm-input-cm._style,jlexcomment .jcm-input-cm._style .jcm-textarea,jlexcomment .jcm-input-cm.active .jcm-text-placeholder,jlexcomment .jcm-map,jlexcomment .jcm-map-status,jlexcomment .jcm-map-status.active,jlexcomment .jcm-media-preview,jlexcomment .jcm-media-preview ._cancel,jlexcomment .jcm-media-preview ._caption,jlexcomment .jcm-media-preview ._desc,jlexcomment .jcm-media-preview ._edit,jlexcomment .jcm-media-preview ._error,jlexcomment .jcm-media-preview ._form_edit,jlexcomment .jcm-media-preview ._process_bar,jlexcomment .jcm-media-preview ._process_box,jlexcomment .jcm-media-preview ._process_cont,jlexcomment .jcm-media-preview ._remove,jlexcomment .jcm-media-preview ._size,jlexcomment .jcm-media-preview ._task,jlexcomment .jcm-media-preview .jcm-ext,jlexcomment .jcm-media-preview .jcm-info,jlexcomment .jcm-media-preview label,jlexcomment .jcm-media-preview._rlt_completed ._edit,jlexcomment .jcm-media-preview._rlt_completed ._remove,jlexcomment .jcm-media-preview._rlt_editing ._form_edit,jlexcomment .jcm-media-preview._rlt_error ._error,jlexcomment .jcm-media-preview._rlt_process ._cancel,jlexcomment .jcm-media-preview._rlt_process ._process_cont,jlexcomment .jcm-mention,jlexcomment .jcm-player,jlexcomment .jcm-player .jcm-player-title,jlexcomment .jcm-player-main,jlexcomment .jcm-player-main iframe,jlexcomment .jcm-player-main.active,jlexcomment .jcm-post-body,jlexcomment .jcm-post-body .jcm_sticker img,jlexcomment .jcm-post-body._styled,jlexcomment .jcm-post-footer,jlexcomment .jcm-post-header,jlexcomment .jcm-post-header .jcm-q-menu,jlexcomment .jcm-post-header .jcm-q-menu a,jlexcomment .jcm-post-header .jcm-q-menu li,jlexcomment .jcm-protect-layer,jlexcomment .jcm-protect-layer.active,jlexcomment .jcm-pull-left,jlexcomment .jcm-pull-right,jlexcomment .jcm-refresh,jlexcomment .jcm-refresh ._sw0,jlexcomment .jcm-refresh ._sw1,jlexcomment .jcm-refresh-sub,jlexcomment .jcm-refresh._loading ._sw0,jlexcomment .jcm-refresh._loading ._sw1,jlexcomment .jcm-refresh.active,jlexcomment .jcm-reply-form,jlexcomment .jcm-reply-form .forGuest,jlexcomment .jcm-reply-form .hovercard,jlexcomment .jcm-reply-form .hovercard + .jcm-form,jlexcomment .jcm-report,jlexcomment .jcm-roles,jlexcomment .jcm-roles li,jlexcomment .jcm-roles li + li,jlexcomment .jcm-sticker-preview,jlexcomment .jcm-sticker-preview ._img_box,jlexcomment .jcm-sticker-preview ._moved,jlexcomment .jcm-sticker-preview ._process_bar,jlexcomment .jcm-sticker-preview ._process_result,jlexcomment .jcm-sticker-preview ._remove,jlexcomment .jcm-sticker-preview ._stir_loading,jlexcomment .jcm-sticker-preview img,jlexcomment .jcm-symbol-limit,jlexcomment .jcm-task-collapse,jlexcomment .jcm-task-expand,jlexcomment .jcm-text-placeholder,jlexcomment .jcm-text-placeholder.active,jlexcomment .jcm-textarea,jlexcomment .jcm-thumb-small,jlexcomment .jcm-tooltip,jlexcomment .jcm-tooltip .jcm-tooltip-body,jlexcomment .jcm-tooltip-body,jlexcomment .jcm-unpublish-msg,jlexcomment .jcm-unpublished

.jcm-unpublish-msg,jlexcomment .jcm-vote-down,jlexcomment .jcm_form_error,jlexcomment .jcm_form_error.active,jlexcomment .jcm_form_input .jcm-btn-cancel,jlexcomment .login-buttons .auth-facebook button,jlexcomment .login-buttons .auth-google button,jlexcomment .login-buttons .auth-twitter button,jlexcomment .login-buttons [class^=\jcm-icon-\],jlexcomment .login-buttons button,jlexcomment .login-buttons.oauth-off button,jlexcomment .page-button a,jlexcomment .page-button.a-disabled a,jlexcomment .page-button.a-selected a,jlexcomment .react-box,jlexcomment .react-box ._act img,jlexcomment .react-box ._label,jlexcomment .react-count,jlexcomment .react-set,jlexcomment .react-stic,jlexcomment .react-total,jlexcomment .reaction-btn,jlexcomment .reaction-btn + .reaction-btn,jlexcomment .reaction-btn ._label,jlexcomment .reaction-btn.active ._label,jlexcomment .symbol-count,jlexcomment .symbol-count.error,jlexcomment a,jlexcomment a._page_next,jlexcomment a._page_previous,jlexcomment a._react,jlexcomment a.active,jlexcomment a.jcm-empty-geo,jlexcomment a.jcm-readless,jlexcomment a.jcm-readmore,jlexcomment button,jlexcomment button.jcm-btn-post.forMember,jlexcomment img,jlexcomment input[type=\email\],jlexcomment input[type=\password\],jlexcomment input[type=\text\],jlexcomment li.jcm-voting,jlexcomment textarea,jlexcomment ul,jlexcomment ul.jcm-childs,jlexcomment ul.jcm-dropdown-menu,jlexcomment ul.jcm-images-slideshow,jlexcomment ul.jcm-images-slideshow li,jlexcomment ul.jcm-inline

li,jlexcomment ul.jcm-inline

li + li,jlexcomment ul.jcm-root-page,jlexcomment ul.jcm-root-page .first a,jlexcomment ul.jcm-root-page st a,jlexcomment ul.jcm-root-page li,jlexcomment ul.jcm-root-page li.a-disabled,jlexcomment ul.jcm-task-list

li + li,jlexcomment ul.jcm-task-list a,jlexcomment ul.jcm-top,jlexcomment ul.jcm-top-secondary,jlexcomment.jcm-xsmall ._controller._member[data-tool=\4\],jlexcomment.jcm-xsmall ._controller._member[data-tool=\5\],jlexcomment.jcm-xsmall ._controller[data-tool=\4\] .jcm-btn-open,jlexcomment.jcm-xsmall ._controller[data-tool=\4\] button.jcm-btn-post.forMember,jlexcomment.jcm-xsmall ._controller[data-tool=\5\] .jcm-btn-open,jlexcomment.jcm-xsmall ._controller[data-tool=\5\] button.jcm-btn-post.forMember,jlexcomment.jcm-xsmall .forGuest,jlexcomment.jcm-xsmall .hovercard,jlexcomment.jcm-xsmall .hovercard + .jcm-form,jlexcomment.jcm-xsmall .hovercard + .jcm-post-content,jlexcomment.jcm-xsmall .jcm-date,jlexcomment.jcm-xsmall .jcm-map-status,jlexcomment.jcm-xsmall .jcm-post-header,jlexcomment.jcm-xsmall .jcm-post-header .jcm-bullet,jlexcomment.jcm-xsmall .jcm-post-header .jcm-q-menu,jlexcomment.jcm-xsmall .jcm-roles li,jlexcomment.jcm-xsmall .jcm_form_input .hovercard,jlexcomment.jcm-xsmall ul.jcm-childs,js-mainnav .dropdown-menu,js-mainnav.darkblue ul.level1 gamenu js-megaMenuToggle .megaMenuToggle-icon,js-mainnav.megamenu .js-megamenu li.megacss .childcontent,js-mainnav.megamenu ul.level1 li.megacss a,js-mainnav.megamenu.darkblue,js-mainnav.megamenu.darkblue js-megaMenuToggle,js-mainnav.megamenu.darkblue .childcontent .group h3,js-mainnav.megamenu.darkblue .childcontent .js-moduletable a,js-mainnav.megamenu.darkblue .childcontent .moduletable,js-mainnav.megamenu.darkblue .childcontent-inner,js-mainnav.megamenu.darkblue .childcontent-inner .group ul li.active,js-mainnav.megamenu.darkblue .group-title .menu-desc,js-mainnav.megamenu.darkblue .group-title .menu-title,js-mainnav.megamenu.darkblue .megaMenuToggle,js-mainnav.megamenu.darkblue ul.level0 li.megacss a.megacss,js-mainnav.megamenu.darkblue ul.level0 li.megacss span.megacss,js-mainnav.megamenu.darkblue ul.level0 li.megacss.submenu-align-left

.childcontent,js-mainnav.megamenu.darkblue ul.level1 li.haschild,js-mainnav.megamenu.darkblue ul.level1 li.haschild-over,js-mainnav.megamenu.darkblue ul.level1 li.over,js-mainnav.megamenu.dault ul.level1 li,js-mainnav.megamenu.noJS css3-megaMenuToggle .megaMenuToggle-icon,js-mainnav.megamenu.noJS ul.megamenu li,jux_memamenu503 arrow-icon,jux_memamenu503 js-mainnav .js-megamenu,jux_memamenu503 js-mainnav .js-megamenu .open .childcontent-inner-wrap.dropdown-menu,jux_memamenu503 js-mainnav .jux-fa.jux-fa-bars,jux_memamenu503 js-mainnav ul.level0,jux_memamenu503 js-mainnav ul.megamenu li.haschild.megacss

div.childcontent,jux_memamenu503 js-mainnav ul.megamenu li.haschild.megacss

div.childcontent.adddropdown,jux_memamenu503 js-mainnav.horizontal ul.level0 li.megacss.submenu-align-center

.childcontent,jux_memamenu503 js-mainnav.horizontal ul.level0 li.megacss.submenu-align-left

.childcontent,jux_memamenu503 js-mainnav.horizontal ul.level1 li.megacss.submenu-align-right

.childcontent,jux_memamenu503 js-mainnav.megamenu,jux_memamenu503 js-mainnav.megamenu arrow-icon,jux_memamenu503 js-mainnav.megamenu js-megaMenuToggle,jux_memamenu503 js-mainnav.megamenu js-megaMenuToggle .megaMenuToggle-icon,jux_memamenu503 js-mainnav.megamenu .childcontent-inner,jux_memamenu503 js-mainnav.megamenu .childcontent-inner-wrap,jux_memamenu503 js-mainnav.megamenu .js-megamenu,jux_memamenu503 js-mainnav.megamenu .js-megamenu li.megacss .childcontent,jux_memamenu503 js-mainnav.megamenu .js-megamenu.dropdown-menucssjs-meganav,jux_memamenu503 js-mainnav.megamenu .megacol,jux_memamenu503 js-mainnav.megamenu .open

.dropdown-menu,jux_memamenu503 js-mainnav.megamenu div.megaMenuToggle,jux_memamenu503 js-mainnav.megamenu ul li ul li arrow-icon,jux_memamenu503 js-mainnav.megamenu ul.level0,jux_memamenu503 js-mainnav.megamenu ul.level0 li a.haschild-over.megacss span.menu-title,jux_memamenu503 js-mainnav.megamenu ul.level0 li a.haschild.megacss span.menu-title,jux_memamenu503 js-mainnav.megamenu ul.level0 li.haschild span.arrow-icon,jux_memamenu503 js-mainnav.megamenu ul.level0 li.haschild-over span.arrow-icon,jux_memamenu503 js-mainnav.megamenu ul.level0 li.megacss,jux_memamenu503 js-mainnav.megamenu ul.level0 li.megacss a.megacss,jux_memamenu503 js-mainnav.megamenu ul.level0 li.megacss span.megacss,jux_memamenu503 js-mainnav.megamenu ul.level0 li.megacss.submenu-align-fullwidth,jux_memamenu503 js-mainnav.megamenu ul.level1 li.haschild,jux_memamenu503 js-mainnav.megamenu ul.level1 li.haschild span.arrow-icon,jux_memamenu503 js-mainnav.megamenu ul.level1 li.haschild-over,jux_memamenu503 js-mainnav.megamenu ul.level1 li.haschild-over span.arrow-icon,jux_memamenu503 js-mainnav.megamenu ul.level1 li.megacss a,jux_memamenu503 js-mainnav.megamenu ul.level1 li.megacss a.megacss,jux_memamenu503 js-mainnav.megamenu ul.level1 li.megacss span.arrow-icon,jux_memamenu503 js-mainnav.megamenu ul.level1 li.megacss span.megacss,jux_memamenu503 js-mainnav.megamenu ul.level2 li.megacss a.megacss,jux_memamenu503 js-mainnav.megamenu ul.level2 li.megacss span.megacss,jux_memamenu503 js-mainnav.megamenu ul.level3 li.megacss a.megacss,jux_memamenu503 js-mainnav.megamenu ul.level3 li.megacss span.megacss,jux_memamenu503 js-mainnav.megamenu ul.level4 li.megacss a.megacss,jux_memamenu503 js-mainnav.megamenu ul.level4 li.megacss span.megacss,jux_memamenu503 js-mainnav.megamenu ul.megamenu,jux_memamenu503 js-mainnav.megamenu ul.megamenu li.megacss a.megacss span.menu-desc,jux_memamenu503 js-mainnav.megamenu.horizontal,jux_memamenu503 js-mainnav.megamenu.horizontal ul.level1 li.submenu-align-right a.haschild-over.megacss span.menu-title,jux_memamenu503 js-mainnav.megamenu.horizontal ul.level1 li.submenu-align-right a.haschild.megacss span.menu-title,jux_memamenu503 js-mainnav.megamenu.megamenu.vertical.right .js-megamenu ul.level0 li.megacss .childcontent,jux_memamenu503 js-mainnav.megamenu.megamenu.vertical.right ul.level0 li.megacss a.megacss,jux_memamenu503 js-mainnav.megamenu.noJS css3-megaMenuToggle,jux_memamenu503 js-mainnav.megamenu.noJS css3-megaMenuToggle .megaMenuToggle-icon,jux_memamenu503 js-mainnav.megamenu.noJS ul.level0 li.megacss.haschild

a.haschild,jux_memamenu503 js-mainnav.megamenu.noJS ul.megamenu li,jux_memamenu503 js-mainnav.megamenu.noJS ul.megamenu li a,jux_memamenu503 js-mainnav.megamenu.noJS ul.megamenu li.haschild

div.childcontent,jux_memamenu503 js-mainnav.megamenu.vertical.left .js-megamenu ul.level0 li.megacss .childcontent,jux_memamenu503 js-mainnav.megamenu.vertical.right .js-megamenu ul.level0 li.megacss .childcontent,jux_memamenu503 js-mainnav.noJS.up ul.megamenu li.haschild

div.childcontent,jux_memamenu503 megamenucss js-mainnav.noJS ul.megamenu li.haschild

div.childcontent,jux_memamenu503 .childcontent.open

.dropdown-menu,jux_memamenu503 .dropdown-menu,jux_memamenu503 .group-title,jux_memamenu503 .megamenu ul.level0 li.megacss a.megacss,jux_memamenu503 .megamenu-sticky,jux_memamenu503 a,jux_memamenu503 ul li ul li div.dropdown-menucss,jux_memamenu503 ul.megamenu li.haschild.megacss

div.childcontent.adddropdown,lg-actual-size,lg-counter,lg-zoom-in,lg-zoom-out,loginComp,loginComp loginBtn,loginForm,logoutForm,map_canvas img,mask,megamenucss js-mainnav .js-megamenu arrow-icon,megamenucss js-mainnav .js-megamenu .childcontent-inner-wrap.dropdown-menu,megamenucss js-mainnav .js-megamenu .dropdown-menu,megamenucss js-mainnav.darkblue .js-megamenu,megamenucss js-mainnav.horizontal ul.level0 li.megacss.submenu-align-center

.childcontent,megamenucss js-mainnav.horizontal ul.level0 li.megacss.submenu-align-fullwidth,megamenucss js-mainnav.horizontal ul.level0 li.megacss.submenu-align-fullwidth

.childcontent,megamenucss js-mainnav.horizontal ul.level0 li.megacss.submenu-align-fullwidth

.childcontent

.childcontent-inner-wrap,megamenucss js-mainnav.horizontal ul.level0 li.megacss.submenu-align-fullwidth

.childcontent

.childcontent-inner-wrap

.childcontent-inner,megamenucss js-mainnav.horizontal ul.level0 li.megacss.submenu-align-left

.childcontent,megamenucss js-mainnav.horizontal ul.level0 li.megacss.submenu-align-right

.childcontent,megamenucss js-mainnav.horizontal ul.level1 li.megacss.submenu-align-left

.childcontent,megamenucss js-mainnav.horizontal ul.level1 li.megacss.submenu-align-right

.childcontent,megamenucss js-mainnav.megamenu,megamenucss js-mainnav.megamenu .childcontent,megamenucss js-mainnav.megamenu .childcontent .group .moduletable,megamenucss js-mainnav.megamenu .childcontent .group h3,megamenucss js-mainnav.megamenu .childcontent .js-moduletable,megamenucss js-mainnav.megamenu .childcontent .js-moduletable .js-box-ct,megamenucss js-mainnav.megamenu .childcontent .js-moduletable a,megamenucss js-mainnav.megamenu .childcontent .js-moduletable li,megamenucss js-mainnav.megamenu .childcontent .js-moduletable ul,megamenucss js-mainnav.megamenu .childcontent .moduletable,megamenucss js-mainnav.megamenu .childcontent .moduletable h3,megamenucss js-mainnav.megamenu .childcontent-inner,megamenucss js-mainnav.megamenu .childcontent-inner a,megamenucss js-mainnav.megamenu .clearfix,megamenucss js-mainnav.megamenu .group-content .js-moduletable,megamenucss js-mainnav.megamenu .group-content ul.megamenu,megamenucss js-mainnav.megamenu .group-title,megamenucss js-mainnav.megamenu .group-title .menu-desc,megamenucss js-mainnav.megamenu .group-title .menu-title,megamenucss js-mainnav.megamenu .js-megamenu,megamenucss js-mainnav.megamenu .js-megamenu .level1 .group,megamenucss js-mainnav.megamenu .js-megamenu li.haschild-over .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.haschild-over .right,megamenucss js-mainnav.megamenu .js-megamenu li.haschild-over li.megacss .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.haschild-over li.megacss .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.haschild-over .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.haschild-over .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.haschild-over li.megacss .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.haschild-over li.megacss .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.haschild-over .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.haschild-over .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.haschild-over li.megacss .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.haschild-over li.megacss .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.haschild-over .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.haschild-over .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.haschild-over li.megacss .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.haschild-over li.megacss .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.megacss li.haschild-over .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.megacss li.haschild-over .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.megacss li.haschild-over li.megacss .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.megacss li.haschild-over li.megacss .right,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.megacss li.megacss li.haschild-over .childcontent,megamenucss js-mainnav.megamenu .js-megamenu li.megacss li.megacss li.megacss li.megacss li.megacss li.haschild-over .right,megamenucss js-mainnav.megamenu .js-megamenu ul.level1,megamenucss js-mainnav.megamenu .js-megamenu ul.level2,megamenucss js-mainnav.megamenu .js-megamenu ul.level3,megamenucss js-mainnav.megamenu .megacol,megamenucss js-mainnav.megamenu div.megaMenuToggle,megamenucss js-mainnav.megamenu span.menu-image,megamenucss js-mainnav.megamenu span.no-title,megamenucss js-mainnav.megamenu span.no-title img,megamenucss js-mainnav.megamenu ul,megamenucss js-mainnav.megamenu ul.level0,megamenucss js-mainnav.megamenu ul.level0 .childcontent .moduletable a,megamenucss js-mainnav.megamenu ul.level0 .childcontent .moduletable li,megamenucss js-mainnav.megamenu ul.level0 li current.active,megamenucss js-mainnav.megamenu ul.level0 li.haschild a.megacss span.menu-desc,megamenucss js-mainnav.megamenu ul.level0 li.haschild-over a.megacss span.menu-desc,megamenucss js-mainnav.megamenu ul.level0 li.megacss,megamenucss js-mainnav.megamenu ul.level0 li.megacss .has-image,megamenucss js-mainnav.megamenu ul.level0 li.megacss a.megacss,megamenucss js-mainnav.megamenu ul.level0 li.megacss span.image-title,megamenucss js-mainnav.megamenu ul.level0 li.megacss span.megacss,megamenucss js-mainnav.megamenu ul.level0 li.megacss span.menu-desc,megamenucss js-mainnav.megamenu ul.level0 li.megacss span.menu-title,megamenucss js-mainnav.megamenu ul.level0 li.megacss.right,megamenucss js-mainnav.megamenu ul.level1 .childcontent,megamenucss js-mainnav.megamenu ul.level1 li a.megacss span.menu-desc,megamenucss js-mainnav.megamenu ul.level1 li.first,megamenucss js-mainnav.megamenu ul.level1 li.group,megamenucss js-mainnav.megamenu ul.level1 li.megacss,megamenucss js-mainnav.megamenu ul.level1 li.megacss a.megacss,megamenucss js-mainnav.megamenu ul.level1 li.megacss span.megacss,megamenucss js-mainnav.megamenu ul.level1 li.megacss.group,megamenucss js-mainnav.megamenu ul.megamenu,megamenucss js-mainnav.megamenu ul.megamenu.level0 .big-img-left img,megamenucss js-mainnav.megamenu ul.megamenu.level0 .big-img-left span.image-title,megamenucss js-mainnav.megamenu ul.megamenu.level0 .big-img-right,megamenucss js-mainnav.megamen

Adding Labels to the Bubbles in an Excel Bubble Chart

You can apply data labels to the bubbles to show the data they represent by right-clicking a bubble so the entire series is selected, then choosing Format Data Labels. Initially only Y values are displayed, but you can choose to add X values, the Z values (bubble size), and more.

What youd really like to do is add data labels of your own design. And even better,how about adding data labels with multiple linesthat include data such as project name, date, revenue, etc. the additional data that might be needed to make decisions.

In Excel 2007 and Excel 2010 heres how to apply custom data labels such as project names,

1. Enter the custom names you want to appear as labels in a column like your data. They do not need to be adjacent to the X, Y data.

2. Right-click a bubble to select all bubbles, then choose Add Data Labels. Y values will appear next to each bubble.

3. Click on a Y-value label to select it, type = in the blank formula bar, click on the cell containing the text label for that bubble, then press Enter. The text in the cell reference will appear adjacent to the bubble as a label.

For Excel 2013 its much easier. You can create custom data labels for an entire data series at one time.

1. Enter the custom names you want to appear as labels in a column like your data. They do not need to be adjacent to the X, Y data.

2. Right-click a bubble to select all bubbles, then choose Add Data Labels. Y values will appear next to each bubble.

3. Right-click on a Y-value label to select all the labels, then choose Format Data Labels.

4. In Excel 2013 you have extra choices. Choose Label Contains Value from Cells. In the dialog that appears choose Select Data Label Range, drag across the cells containing your data labels, then click Ok.

All the bubbles will be labeled at one time.

At this point you may want to select a single label or all labels and reposition them, change the font, or label background.

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

Subscribe to Get the Excel Chart Top Tips PDF!

Get our newsletter for independent professionals and instant access to the Excel Chart Top Tips PDF!

Advanced Excel Training and Support for Free

Awesome Excel Basic and Intermediate Training for Free

10 Top Tips for Creating an Excel Budget or Excel Budget Template

Top 26 Best Excel Conditional Formatting Tips and Tutorial