Solved

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

Posted on 2011-09-13
4
213 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

Expert Comment

by:Ingeborg Hawighorst
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 earned 500 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

830 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