How to create a floating bar chart vertically not horizontally...


        
0
Cristina (11)
6/30/2006 3:15:03 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
543 Views

Similar Articles

[PageSpeed] 10

Hi,

The technique is the same for both column and bar charts, which is to 
use a stacked chart and remove the formatting from the series used to 
'float' your data.

See Jon's explanation.
http://peltiertech.com/Excel/Charts/FloatingColumns.html

Cheers
Andy

Cristina wrote:

-- 

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
0
andy9699 (3616)
6/30/2006 8:45:49 PM
Reply:

Similar Artilces:

combining stacked with side-by-side bar
I need a graph which has a combination of horizontal bars (could do vertical as well, though doubt it matters for whether this can be done), where for each series, one of the bars is a stacked, two data point bar, and the one NEXT to it is a single data point. In other words, I have the following data: Type 1 Type 2 Type 3 EuropeA EuropeB US A US B There are more types, but this is the example. I need Type 1 to be 2 bars, one with a stack of Europe A and B, and next to it, a stack of US A and B. Then I need Type 2 as the next category to show two similar side-...

Excel 2000
Is there a limit to the number of slices in an Excel 2000 pie chart. I can only get (9) to work using the wizard. As soon as I add (10) the last one gives an error readin and it sits there incomplete. Hi, There are limits but it's not 10. What data do you have in those 10 cells? Cheers Andy Bob wrote: > Is there a limit to the number of slices in an Excel 2000 pie chart. I can > only get (9) to work using the wizard. As soon as I add (10) the last one > gives an error readin and it sits there incomplete. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info I a...

vertical message
received an email message that reads vertically. How to change the type to run horizontal? "christian g" <christian g @discussions.microsoft.com> wrote in message news:D65FB421-4BF1-4E98-844D-B2FFE36F89B4@microsoft.com... > received an email message that reads vertically. How to change the type to > run horizontal? Why do you believe the sender's PC isn't the cause of this? Outlook should be displaying what you received. -- Brian Tillman [MVP-Outlook] ...

Changing chart background color in Excel 97 SR 2
I am fairly new to this so please bear with me. I have a chart based on numbers in a spread that has a grey background (The chart) but I would like the background to be white and can not get it to change. I right clicked on the chart and went to Format Chart Area, Patterns, Fill Effects, Patterns and changed the background to white but the ok button is greyed out. Am using Excel (Office) 97 SR 2 TIA http://members.aol.com/larrystark/ Right click (or double click) on the gray region, which is the Plot Area. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tut...

Need Help with Creating a Multi-part Rule for Outlook 2003
Hi all -- Has anyone else come across the need to do the following: * Have a rule that copies and then forwards all non-domain generated e-mail to another e-mail address. For example: - Have all e-mail sent by anyone within the xyz.com domain to remain in the Inbox, but anything not sent by someone within xyz.com will be copied and forwarded to another recipient. If any one knows of a way to accomplish the above or if it is not possible, please reply here. Sincerely, Ralph Greenberg, MCSA Set a rule to copy/forward all mail items (no defining crit...

Combo Boxes in Charts
I have created a chart which includes a combo box which refers to a list of names. The problem is that the font size is too small - size 10 - and I would like to make it bigger. Have tried changing the font size of the data range for the combo box but this has no effect. The properties of the combo box let me change its size but not the font size of the list of items. Any suggestions. Thanks Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=83...

Background picture behind chart
In Excel I have successfully inserted a picture behind an interactive chart so the chart (graph) is visible overtop of the picture. But when I Save as Web Page the picture doesn't show up. The graph is fine, and is interactive, but the background picture file (gif) has disappeared. How can I preserve the picture so it will save as part of the Web Page? Thanks. Ralph Hi, Not tested but could you use the picture as the Fill Special for the chart or plot area? Cheers Andy RalphB wrote: > In Excel I have successfully inserted a picture behind an interactive chart > so the...

create rule based on the DISPLAYED from field
Hi Group, I'm using Outlook 2007. Is it possible to create a rule that searches the text displayed in the "from" field? I would like to delete messages with certain offensive words in the "from" field, but I'm unable to find any rule that does that. I can see the words of "interest" if I go to Message options / Internet headers, but how do you build a rule based on that ? thank you, andy use a 'words in the header' rule. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchan...

Tool bar hide in Ac2007
I have an application written Ac2000 that runs fine on computers using Ac2003. A new user installed Ac2007. Part of the program startup procedure applies code to hide toolbars (docmd.ShowToolbar etc.). Normally, the main switchboard form then covers the whole screen. With Ac2007, the toolbar does not hide. Not only does the toolbar show, but an object list also displays on left screen. What kind of code can I write to hide the toolbar and object list. Is there also code that will allow the program to know that it has opened in Ac2007? ...

Can't Download Updates
Hi Guys, I cannot download the windows updates for vista 64-bit. I get to the part where it's starting to download, and then the blue bar just circles and circles and then eventually hangs my whole computer up. Never had this problem before, can connect to the internet, updated last on 3/6. My computer started acting very strange the last few days, won't shut down regularly, keeps hanging when I try so I need to hard power off. Programs are running slow, especially control panel type stuff. I've searched it for Viruses (using AVG) and spyware/malware using W...

Create link in publisher to folder stored on same web site
I created my web page in Publisher and succesfully published it. I draged and dropped a folder on my ftp site. I tried, without success, to place a hyperlink from my web page to open the folder. Please advise if it is possible to create the link and of so how it can be done. Thanks. Bob. On your webpage use a name or image, i.e., The cars folder is available here. Using the mouse highlite the word here and select Insert, Hyperlink. The hyperlink would read /cars Note the cars folder and the link to it are case sensitive. That's it. don Vancouver, USA "Bob W" <Bo...

Domain Admin can't create mailbox
I think I may have worked myself out of a certain permission and I can't figure out which one it is. I'm a domain admin but I can't add a mailbox to a user account through ADUC. Most time, running domainprep will solve permission problems, without negative impacts... -- "JBeckett [MCSA]" <JBeckettMCSA@discussions.microsoft.com> wrote in message news:1B2DBE79-A70B-4300-9504-2BD599EBB781@microsoft.com... >I think I may have worked myself out of a certain permission and I can't > figure out which one it is. I'm a domain admin but I can't add a ...

Do rules created in Outlook apply to external emails received?
We are posting a few jobs for our company. What I did was created 2 new accounts and email addresses and gave permissions to the Director who now can open their Inbox within her Outlook. I created a new rule for each mailbox that states email "Sent only to me" to apply this rule "Have server reply using a specific message". Basically the message is the auto response email stating thank you and we have recieve your resume. I've tested from my internal account and get the auto response with the message and our company logo just like I set it up. However I do not ge...

How do I add a floating text box in Excel?
I have a shared workbook with several huge spreadsheets. There are certain things that other users/viewers would readily want to know without parsing to the end of the spreadsheet. How can I create a floating text box in Excel and include totals of certain cells from the same worksheet? MS has lots of templates at: http://officeupdate.microsoft.com/TemplateGallery And there's always google! Prashant wrote: > > I have a shared workbook with several huge spreadsheets. There are certain > things that other users/viewers would readily want to know without parsing to > the...

Cannot create C# proxy for Axis SOAP service?
I've goggled a few posts about this but haven't found a definitive answer. I have an Apache Axis SOAP web service that I ned to write a C# client for. When I point VS.Net Studio 2003 at my Axis WSDL, I get the following error message from VS.net: - Report from 'WSDL Document' is 'There is an error in XML document (46, 16).'. - Namespace prefix 'impl:urn' is not defined. - Report from 'DISCO Document' is 'Discovery document at the URL http://10.3.158.101:8080/DDServer/services/urn:DDSoapService?wsdl could not be found.'. - The document fo...

Creating a new form everytime a contact is made
I have created a database in Access 2003 to keep track of all of the data needed for our hospital based bariatric program. The forms created work well. However now my problem arises that originally there was one contact about a month after surgery and the information filled in. Now the staff would like to show multiple contacts for that same patient using the same questions but on differant days or months. What I am trying to avoid is creating a giant form with the same fields listed six times because they might contact the patient once a month for six months or possibly daily ...

All formatting not saving in Chart Template 04-07-10
Hi, sorry if this has been answered. I am new to Chart templates. I created a pivot chart and saved it as a template. When I bring it back up again, not all of the formatting is saved. For example, the title is just "Title" and I had data values being shown and they are not, and also the colors of the columns are not the same. Is there any way to save all of these as part of a template? thanks, Varvara ...

Publishing to Web
We have just upgraded from Publisher 2000 to 2003. Now when we publish to the web each of the images creates their own page with a link back to their original location; and the file which has 38 pages when open in the computer has over 600 pages when viewed from the internet. What has happened? How can we fix this? ...

Legend in charts
how do i change the legends in multiple charts to read the same thing? Hi, In what way? The legend reflects what is in each chart, so if your charts are different, so will your legends be. Or are you referring to the formatting? Dave "queenie" wrote: > how do i change the legends in multiple charts to read the same thing? ...

Use Query or Macro to Creat enew Database
I need to figure out a way to create a new database from within an existing database during a process in which i am running several queries. the new database name will have a generic name like "Quarterly..." but will then be concatenated with the quarterly submittal date in a specific format (e.g., 20070601) I'm thinking i could create a query to determine the quarterly date and then concatenate with the other part of the file name, but how would i actually create a process for creating a new database (in a specified directory) from within my existing directory. any sugg...

Previewing the email a template creates
In my opinion ... and I'm almost always right : ) ... Templates are of no use unless the subsequent email can be previewed. Users are not going to select 50 leads and send them an email without being able to view the text and formatting on its way out. The template may have been created by someone else which means the user would be taking an enormous leap of faith in using the template. That’s just asking for trouble. Likewise, a Customer Service rep wouldn’t use a template to tell a customer how to fix a particular issue unless they could preview the email. I assumed the deve...

Auto Scaling Charts
I am trying (in Vain) to auto scale bar charts in excel. I have attempted a macro in VB to do this, but it just seems to do nothing, does not fail or succeeds. If anyone could take a look at the macro below and assist in where it is going wrong would be much appreciated. Thanks Sub AutoScaleCharts() Dim ws As Worksheet Dim cht As ChartObject Dim ValuesArray(), SeriesValues As Variant Dim Ctr As Integer, TotCtr As Integer For Each ws In ThisWorkbook.Worksheets For Each cht In ws.ChartObjects For Each X In cht.Chart.SeriesCollection SeriesValues = X.Values ...

Trying To Add a Line to an Excel chart using variable cell values
I'm using an XY Scatter chart and I want to draw a straight line between 2 points which passes through a 3rd point on the chart. The line represents the Security Market Line (relating risk and return) with Standard Deviation on the X axis and Portfolio Return Percentage on the Y axis. One point is the 3 Month TBill. The point that the line is passing through is an index point (e.g. S&P 500) and the 3rd point will be one that is calculated based on the slope of relationship between the TBill point and the index point. The 3rd point needs to be plotted on either the top or bott...

How to print 15 embeded charts on two sheets at once?
Hello specialists! How to print 15 embedded charts (without data cells) on two sheets at once? Best regards, Dima kopnichevdi@lukoil.comDelete You don't want data cells. Does that mean you want each chart printed on its own page? This cannot be done without a macro. Do you instead want just the portion of the worksheet with the charts to be printed, but not the portion of the sheet with the data? Select the range containing the charts, and set the print area (File menu > Print Area > Set Print Area. Repeat for the other worksheet, then select both (click on one, ctrl+click on...

i can't see a chart i made, all i get is blue worksheet
when i make a chart, it will appear in worksheet with original data. when i move to its own chart worksheet, all I get is a blue window. What am i doing wrong? Are you selecting the chart and then moving it choosing the command Chart, Location...? -- Thanks, Shane Devenshire "drwink" wrote: > when i make a chart, it will appear in worksheet with original data. when i > move to its own chart worksheet, all I get is a blue window. What am i doing > wrong? ...