Heather has attended:
Excel Intermediate course
Excel Advanced course
Outlook Advanced course
PowerPoint Intermediate Advanced course
Word Advanced course
Charts - displaying both date ranges and exact date
I would like to create a bar/line chart with two axis. The X axis would represent date - I want the bar section of this graph to represent quarters (i.e. a date range) but the line to represent a specific date. Is this possible? If so how can i do this?
Thanks!
Heather
RE: Charts - displaying both date ranges and exact date
Hi Heather,
Thanks for your question.
It's tough to make a 2axis bar/line with dates, you need to customize the chart.
1) Data Table must contain minimum of 3 columns:
- Labels
- Quarters (dates type)
- Dates (dates type)
2) Create a bar chart with the table
3) Select the series of Dates in the bar chart, right click for Source Data, format them into Secondary Axis
4) Finally, right click the series of Dates again, change the chart type to Line.
See if that works.
Katie
