excel+courses - charts displaying both

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Charts - displaying both date ranges and exact date

excel+courses - Charts - displaying both date ranges and exact date

resolvedResolved · Low Priority · Version Standard

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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips


Server loaded in 0.08 secs.