Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multi data charts
I want to build a chart which shows the year on the horizontal axis and the
totals on the vertical axis. The tough part is there are six diiferent data series for each year that when summed give the total for the year. I want to show one bar for each year with each individual data point stacked on top of each other to show the total bar size. I've done it before with 2 series but can't get it to work with six. Help! |
#2
|
|||
|
|||
are you using the stacked column chart?
"thomas donino" wrote: I want to build a chart which shows the year on the horizontal axis and the totals on the vertical axis. The tough part is there are six diiferent data series for each year that when summed give the total for the year. I want to show one bar for each year with each individual data point stacked on top of each other to show the total bar size. I've done it before with 2 series but can't get it to work with six. Help! |
#3
|
|||
|
|||
I was trying to but it wasn't working properly
"bj" wrote: are you using the stacked column chart? "thomas donino" wrote: I want to build a chart which shows the year on the horizontal axis and the totals on the vertical axis. The tough part is there are six diiferent data series for each year that when summed give the total for the year. I want to show one bar for each year with each individual data point stacked on top of each other to show the total bar size. I've done it before with 2 series but can't get it to work with six. Help! |
#4
|
|||
|
|||
If any of your numbers are negative, the stacked bar chart won't work
properly. you have to play with the numbers ot get them to total where you want them to. if none are negative, what are you getting that is wrong? "thomas donino" wrote: I was trying to but it wasn't working properly "bj" wrote: are you using the stacked column chart? "thomas donino" wrote: I want to build a chart which shows the year on the horizontal axis and the totals on the vertical axis. The tough part is there are six diiferent data series for each year that when summed give the total for the year. I want to show one bar for each year with each individual data point stacked on top of each other to show the total bar size. I've done it before with 2 series but can't get it to work with six. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
XL Charts: Let my mouse drag all data labels for a whole series. | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |