Solved

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

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

615 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