-
Looking for a smarter way to manage your heating this winter? We’ve been testing the new Aqara Radiator Thermostat W600 to see how quiet, accurate and easy it is to use around the home. Click here read our review.
Exel Charts
- Thread starter Doug99
- Start date
- Joined
- 5 Nov 2024
- Messages
- 3,703
- Reaction score
- 1,869
- Country
Not entirely sure what you’re asking, as we don’t know what data comparatives you have. Did you know there’s often a chart wizard which can help you with it?
D
Deleted member 323070
Highlight the are of data that you want to use and click on one of the diagrams of your choice.
But you might have to play about with the axis, in so far as what data you want on what axis.
For instance, if you have number of something in one column, and dates in another column, you can swap which column is your x axis, and which is your y axis.
Sorry I can't help much more for now 'cos I'm going out now, and won't be back till late tomorrow.
But if you still need help then, i'll do my best.
D
Deleted member 323070
A bit more info'
This is one I just knocked up
It might be easier to highlight one set of values, e.g. Values in column A, then select from "Insert" select the line graph from the options
Choose the first one in the list to start with
This should give you a graph with your highlighted values and nothing more
Then you can play with selecting your other data ranges
Right click in the graph area, and you'll have a choice of selecting the data
Then you can play about with the data ranges and the labels.
To format the graph with additional info', click on the plus sign at the top right
And you'll get the panel at the left (depending on screen position of course) and as you use your pointer down the list of options, you'll see the differences it makes.
It'll probably take you some playing about with it to get familiar.
Then you can move onto more impressive presentations.
This is one I just knocked up
It might be easier to highlight one set of values, e.g. Values in column A, then select from "Insert" select the line graph from the options
Choose the first one in the list to start with
This should give you a graph with your highlighted values and nothing more
Then you can play with selecting your other data ranges
Right click in the graph area, and you'll have a choice of selecting the data
Then you can play about with the data ranges and the labels.
To format the graph with additional info', click on the plus sign at the top right
And you'll get the panel at the left (depending on screen position of course) and as you use your pointer down the list of options, you'll see the differences it makes.
It'll probably take you some playing about with it to get familiar.
Then you can move onto more impressive presentations.
D
Deleted member 323070
- Joined
- 22 Aug 2006
- Messages
- 7,049
- Reaction score
- 1,171
- Country
I've used excel charts quite a bit. I've found the setting of some things is buggy, eg you may be able to set somethig bt not unset it.
I keep a few charts in a spare file for copying, because they can be such a pain to set up.
I keep a few charts in a spare file for copying, because they can be such a pain to set up.
D
Deleted member 323070
Power Point is a lot easier for straightforward charts:
With a new page, click on Insert, then Chart. I selected a simple Line Chart.
You can create some values within Power Pont. Or you can use values from an existing Excel sheet, by Copying and Pasting each Column into the PowerPoint presented spreadsheet, which is what I did. It's probably possible to open a pre-existing Spreadsheet to use.
You can see how I am building the chart by selecting each column for the next set of values:
The A column is the X axis, and the subsequent columns become the Series on the Y axis. Each subsequent column becoming the next series.
You can get the same options as in Excel for enhancing your chart presentations:
With a new page, click on Insert, then Chart. I selected a simple Line Chart.
You can create some values within Power Pont. Or you can use values from an existing Excel sheet, by Copying and Pasting each Column into the PowerPoint presented spreadsheet, which is what I did. It's probably possible to open a pre-existing Spreadsheet to use.
You can see how I am building the chart by selecting each column for the next set of values:
The A column is the X axis, and the subsequent columns become the Series on the Y axis. Each subsequent column becoming the next series.
You can get the same options as in Excel for enhancing your chart presentations:
Last edited by a moderator:
