Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

885 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