Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default add multiple x values to multiple instances of y coordinate

I have days of the month on the Y axis and a set of other numbers on the x axis. If I have 2 cells which are both labeled August 15th (for example), I want the data that corresponds to this entry to be added together along the x axis on the chart. Right now, the two sets of data do both show up on the August 15th bar, but subdivided within a single bar rather than being added together. Is there a way to do this?
Thanks

for example:
A, B
aug 15th, 8
aug 15th, 10

I want the bar to show 18 rather than the bar being subdivided to show both the 8 and 10 and only going up to 10 on the x axis
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple instances of Excel (Multiple workbooks) Shane Setting up and Configuration of Excel 3 November 13th 09 06:07 PM
Multiple Instances for Multiple Monitors... Steve P[_2_] Excel Discussion (Misc queries) 4 November 19th 08 10:13 PM
Create list of unique instances from list of multiple Instances Dishon Excel Worksheet Functions 0 March 3rd 08 11:46 AM
Multiple instances Neil Levy Excel Discussion (Misc queries) 2 June 23rd 07 01:13 AM
Multiple instances of Excel Carol Crowley Excel Discussion (Misc queries) 9 March 17th 06 07:18 PM


All times are GMT +1. The time now is 01:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"