Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Add a 3rd bar type in the graph (excel 2003).

Posted on 2011-09-13
4
Medium Priority
?
218 Views
Last Modified: 2012-05-12
Looking to have the 3rd bar showing a #4.  This bar should be split in 4 and another section above reaching 25.

Thanks,
JP a Extra-bar-question.xls
0
Comment
Question by:easycapital
[X]
Welcome to Experts Exchange

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

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 50
ID: 36528404
Hello JP,

I'm afraid I don't understand your question and I don't understand your data.

Why does Product D get plotted on the secondary axis? Why does the total row show the value in the Product D column?

What do you mean with  "Looking to have the 3rd bar showing a #4."?? The black column shows a data label of 4. Are you talking about that black column? How should it be split in 4?

Can you mock up the desired results with the drawing tools to show us what your chart should look like?

cheers, teylyn


0
 

Author Comment

by:easycapital
ID: 36535218
Hi Teylyn,

Thank you for offering to help.

1
The bar indicating value of 4.  Should be a stacked bar, the rest should reaming as is.
2
I am trying to indicate the volume in the current region (January and February).  Each month with a vlaue of 2 (so it is correctly indicated).
3
Then I need a third bard indicating the sum of Jan and February as the bottom portion of a stacked bar, while the other regions equal a value of 21.  So this stacked bar would clearly indicate the portion of the total for all the regions in months Jan and February.
4
Once I know how to address January and February, I would then do March, April and so on, in the same manner.

My difficulty is doing step 3 above.
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 36535311
Hello JP,

>> 1
The bar indicating value of 4.  Should be a stacked bar, the rest should reaming as is.

Stacked what?  Stack on to what? Where is the relationship? Where is the data?


>>2
I am trying to indicate the volume in the current region (January and February).  Each month with a vlaue of 2 (so it is correctly indicated).

Region? What region? The data table shows values for January and April for several products. Where does Feburary come in? Where does the data show a relation to a region?

I really have no idea what you would like to see in that chart.

Please whip out the drawing tools in Word or Excel and manually create a drawing of what you would like the chart to show.

The data table in your spreadsheet does not make any sense and it does not match with your description.

You have one value for January and one value for April. Nothing for February. There is no region indicator in your data.

Please understand that Excel charts can only display data that is present in a data source table. If you want to chart by region, then the source data must have data for a region. Your table does not have such data.

Also, you have not answered my questions in the first comment.

I'm trying to understand what you want to do. If you don't answer my questions for clarification, I won't be able to help.

cheers, teylyn
0
 

Author Closing Comment

by:easycapital
ID: 36908764
Hi Teylyn,
I am not able to clearly express what I am looking for.  
I presented the graph as I had done it from the beginning.
Perhaps my next question will be better explained.
Thank you for the help you provide.
JP
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

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

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

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

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

Join & Ask a Question