ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Using Chart Wizard (https://www.excelbanter.com/charts-charting-excel/39993-using-chart-wizard.html)

Steved

Using Chart Wizard
 
Hello from Steved

='Period.3-06'!$F$5:$J$5,'Period.3-06'!$F$25:$J$25,'Period.3-06'!$F$90:$J$90

Question I have labeled the next sheet Period.2-06

='Period.3-06'!$F$5:$J$5,'Period.3-06'!$F$25:$J$25,'Period.3-06'!$F$90:$J$90,
+'Period.2-06'!$F$5:$J$5,'Period.2-06'!$F$25:$J$25,'Period.2-06'!$F$90:$J$90
it is giving me "The Formula You Typed Contains An Error.
This is my first attempt at doing graphs. What Have I not done Correctly
Please.
Thankyou.

Steved

Hello from Steved

the answer is
=SERIES("Accident At
Fault",'Period.3-06'!$F$6:$J$6,'Period.4-05'!$F$90:$J$90,2)

"Steved" wrote:

Hello from Steved

='Period.3-06'!$F$5:$J$5,'Period.3-06'!$F$25:$J$25,'Period.3-06'!$F$90:$J$90

Question I have labeled the next sheet Period.2-06

='Period.3-06'!$F$5:$J$5,'Period.3-06'!$F$25:$J$25,'Period.3-06'!$F$90:$J$90,
+'Period.2-06'!$F$5:$J$5,'Period.2-06'!$F$25:$J$25,'Period.2-06'!$F$90:$J$90
it is giving me "The Formula You Typed Contains An Error.
This is my first attempt at doing graphs. What Have I not done Correctly
Please.
Thankyou.



All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com