98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Graphs
excel training courses - Graphs
Resolved · Low Priority · Version Standard
Penny has attended:
Excel Intermediate course
Excel Advanced course
Graphs
Is there a way of changing your graph to a 2x bar, 1xline graph without going through the chart types? i.e. is there a way of selecting your third series of data when you cannot see it on the graph?
RE: Graphs
Hi Penny,
Thanks for the question,
To change the initial setting of your default chart you create a normal standard chart, and from there change the standard chart to how you would like it to appear each time. In this case a 2xbar and 1xline.
Still in the "new" chart, go to the chart menu and down to Chart types, make sure you are in the tab that says Custom Types, and click the radion button at the bottom that says "user define", then click the button that says "Add". Give your chart a name and a description (optional), click OK, then click the button "Set as default chart" and it should work.
The second part of your question, I would use the Chart toolbar, specifically the selection (drop down) box to find the series you are looking for if you can not see it on the Chart.
Let me know if it works
Tracy
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:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |