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 » advanced excel training - Excel, charts
advanced excel training - Excel, charts
Resolved · Low Priority · Version Standard
John has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel, charts
I have a chart based on data from a worksheet, i want to be able to add the same format of data from other worksheets within the same file to the chart in order that the chart continues (ie a continous line chart based on month on month data housed within seperate worksheets
Thanks
John
RE: Excel, charts
From playing around with excel, you will notice that the chart button greys out if you try to chart data from several sheets.
You might want to try and create a summary sheet that pulls all the infor from the various sheets onto one so that you can chart that.
Regards
Richard
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:Convert a column into row quickly in Excel 2010Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa. |