Dear Amazing Excel World Team,
I have tried to set a chart as the "Set As Default Chart" in Excel 2007, but it won't work.
I create a chart, select it, and then click on "Set As Default Chart" button in the Chart Tools, Design ribbon, Type, Change Chart Type,Type area.
Any ideas?
I am currently typing a report in Word and prefer to use Times New Roman font to produce reports and letters. I would like to use the same font in excel charts by default. I know how to change the values manually for each entry such as the chart title, axis titles and legend. However I would like to set Times New Roman as the default font across the board.
Any help would be greatly appreciated.
I really like that excel 2010 gives you standard templates that look nice, but I'm not happy with the colors that I get when using these standard templates.
For example, I like that I can go to Chart Tools -> Design and choose the chart style in row 3, column 2 -- however, I do not like the colors that the program defaults to.
There must be a way to change the order of default colors -- please show me how.
Thanks!
I am trying to chart some data that is output by an application, following is the basic format of the data. Any help would be appreciated.
I am trying to do a line chart or a scatter chart with the data points connected where on the X axis "DATA1" would be one line, "DATA2" would be another line, and the date/time would be on the Y axis.
Date,Time,extra data(do not graph),Data Name,Data Point(seconds)
eg.
"2009/10/26","15:30:50","extradata","DATA1","3.937"
"2009/10/26","15:30:54","extradata","DATA2","3.391"
"2009/10/26","15:31:0","extradata","DATA3","4.797"
"2009/10/26","15:31:2","extradata","DATA4","1.953"
"2009/10/26","15:31:4","extradata","DATA5","2.093"
"2009/10/26","15:31:8","extradata","DATA6","3.469"
"2009/10/26","15:31:12","extradata","DATA7","4.438"
"2009/10/26","15:31:30","extradata","DATA8","17.813"
"2009/10/26","15:31:31","extradata","DATA9","0.671"
"2009/10/26","15:31:33","extradata","DATA1","0.531"
"2009/10/26","15:31:35","extradata","DATA2","1.937"
"2009/10/26","15:31:40","extradata","DATA3","3.313"
"2009/10/26","15:31:42","extradata","DATA4","1.813"
"2009/10/26","15:31:44","extradata","DATA5","1.562"
"2009/10/26","15:31:48","extradata","DATA6","4.453"
"2009/10/26","15:31:52","extradata","DATA7","3.922"
"2009/10/26","15:32:1","extradata","DATA8","9.5"
"2009/10/26","15:32:2","extradata","DATA9","0.484"
"2009/10/26","15:32:4","extradata","DATA1","0.563"
"2009/10/26","15:32:6","extradata","DATA2","1.782"
"2009/10/26","15:32:10","extradata","DATA3","2.36"
"2009/10/26","15:32:11","extradata","DATA4","1.672"
"2009/10/26","15:32:13","extradata","DATA5","1.25"
"2009/10/26","15:32:16","extradata","DATA6","3.25"
"2009/10/26","15:32:20","extradata","DATA7","3.891"
"2009/10/26","15:32:29","extradata","DATA8","9.313"
"2009/10/26","15:32:30","extradata","DATA9","0.562"
(BTW, I am a total excel newbie, so sorry if the question is a: too easy, or b: doesn't make sense)
I am going insane trying to figureout how to change the default line style width from 2.25 pts in excel 2007. The line is just so fat that it does not work for me.
I have tried saving a chart I made as a template and then applying that template to other charts. Usually the 1st few sets of data will have the proper line width, but the rest default to the thicker line width.
To change the line width I right click the line of data and choose format data series then Line Style which takes me to width, which defaults to 2.25 pt. That is the value that I would like to change to a default of 1pt.
Can this be done? I have tried most of the day and have not come up with a way to change it.
Hello everyone, hope someone here can help.
Although I have no problem cycling through my chart lines and chaning the thickness (there's a fair few series of data here) I need to provide this chart to a client who will then be able to select pivot chart data and it will automatically chart the relevant lines.
Currently any additional series I plot doesn't retain the chart style of the previous lines.
I need the 'Chart style' to have the differing colours (as it is by default) but with a much lower line thickness (due to the proximity of the data points in places I'm using 0.25pt line thickness)
any ideas?
The code below attemps to read the the DEFAULT series foreground color, however reading the .forecolore property is always set to the same value (16777215) for every series regardless of how many series are present
Please comment
Tony
With oChart.TrendChart
For i = .SeriesCollection.Count To 1 Step -1
With .SeriesCollection(i).Format.Line
oChart.TrendLegend.SetColor(i) = .ForeColor' < Fails to read Default color always 16777215
.ForeColor.RGB = RGB(100 * i, 0, 0)'
Using Excel 2000
I am attempting, what is fast becoming apparent to be a lifetime study, to
learn about PivotTables/PivotCharts - they are powerful and facinating. I
am not a novice with Excel.
However, no matter the dataset or configuration of resulting array; whether
attempting chart after table has been created or selecting "PivotChart (with
PivotTable) at the beginning, when attempting to create a pivot chart from
my data this error occurs: "Cannot apply the default chart type to the
selected data."
I cannot find an "option" or configuration that would disallow creation of
charts or change "default chart type". So, are there any ideas as to what
the problem may be - user brain fart notwithstanding?
TIA
I created a Pivot chart from Pivot table, however, as the user changes the
options (from pivot fields), then the chart type changes back to default one
(I want the line-column 2 axes one). I figured I could go to VBA properties
to default the chart type by choosing the chart code, however under that
list, there is no chart code for that combination chart (line chart + column
chart with 2 axes). How can I do this?
Can someone help... as I am not good at VBA? Thanks!
