98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table / Slicer / Charts
Pivot Table / Slicer / Charts
Resolved · High Priority · Version 2013
Thu 9 Jul 2015, 14:32Delegate Sheryl said...
Sheryl has attended:
Excel Pivot Tables course
Excel Dashboards for Business Intelligence course
Pivot Table / Slicer / Charts
Hi
I have a spreadsheet that maps hours against what we have charged on a monthly basis and YTD.
So first column is the client
Second is Jan Charged
Third is Jan Hours
Fourth is Feb Charged
Fifth is Feb Hours
etc etc
I'm trying to produce a combo chart with Jan Charged on on axis as a column chart and hours as a line chart -
Is my data set up incorrectly?
Also would love to have this as a pivot chart and be able to choose a month as a filter, but this doesn't seem to work. Help please!!
Thanks
Kind regards
Sheryl
Thu 9 Jul 2015, 19:02Trainer Doug said...
RE: Pivot Table / Slicer / Charts
Hi Sheryl
You should be able to create a combination chart from your data.
Step 1 - Highlight the client names, Jan Charged and Jan Hours data and create a column chart.
Step 2 - Click the Format tab and select the Jan Hours series from the naavigator at top left of Format tab.
Step 3 - Change the second series to line chart and secondary axis (see attached screenshot).
You will need to copy the chart for next month and change the data range etc.
To be able to filter by month you will have to rearrange the sheet quite a bit. Have headings called Client, Month, Charged, Hours.
Hope that helps for now.
Regards
Doug
Best STL
Attached files...
combochart.pngFri 17 Jul 2015, 13:35Trainer Richard said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Fri 24 Jul 2015: Automatically marked as resolved.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Transpose textYou can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps: |
