Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I'm trying to create a graph showing sales results for 5 organizations over 3
individual quarters, for current and prior year. My plan was to show current year as a bar chart with the 5 organizations each having their own bar for each quarter (therefore there will be 15 bars). I then want to show the prior year data as a line chart, again 5 lines and 15 data points. I've tried several options and my issue is that the data points (labels) for the line charts are in line, in the middle of each quarter, and I would like the data labels to begin and terminate within the corresponding bar. That is, I'd like to see the data point for business A, prior year, inside the bar for Business A, current year, and the same scenario for the other 4 businesses. Is this possible |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I calculate year vs. year sales in a percentage? | Excel Discussion (Misc queries) | |||
calculate prior calendar year end from a moving current date | Excel Worksheet Functions | |||
Entering Dates for a Prior Year | Excel Discussion (Misc queries) | |||
Dates change to prior year when page moved to new book | Excel Discussion (Misc queries) | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel |