Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2011-09-13
4
Medium Priority
?
226 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
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

595 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